I am trying to pull information from one sheet to the next, however I am having trouble trying to make it show the number 6 if it is less then 6 for example...

If I pull information from worksheet Open1 Cell K7 I understand I do this using: =SUM('Open1'!K7)

If in Cell K7 the number is less then 6 I would like for it to show instead of a number less then 6 show the number 6, at the same time if the number is 6 or greater I would like for it to show that number without alteration. I tried messing with the IF function, but I kept getting numbers showing up in the thousands from a number that was 188...

I am sure I keep messing it up and its something simple..

`if()`

function should not have been returning values in the thousands - something is very wrong. While there are two solutions posted below that will solve your trouble, you should also post what you tried and we can tell you why it didn't work. In general you should always post what you tried - it gives people a starting point to help out from. – Adam Sep 8 '15 at 16:49