Question by hazybuck: Excel formula =(IF(‘Enter Info On This Tab’!$ AZ31>0,’Enter Info On This Tab’!$ AZ31,”")?
In the formula above, I’m allowing the data to me over only if it’s greater than “0″. I also need to round up the data if it’s less than .49 because I can not have any zeros come across. I’d like to figure out a way to ROUNDUP .49 and less, and simply round anything over .5.

Any suggestions?

K

Best answer:

Answer by expletive_xom
what did you want to round anything below .5 too?
i think you can just use the max() formula…in other word you are setting a minimum amount to your cell, by forcing anything above 0 to show the minimum you decide on.

hope this helps

if AZ31 = .49
if you want to round it to 1
copy&paste this formula

=IF(‘Enter Info On This Tab’!$ AZ31>0,MAX(1,’Enter Info On This Tab’!$ AZ31),”")

problem is this will round stuff like .50 and .70 to 1

if you want .49 to round to .50

=IF(‘Enter Info On This Tab’!$ AZ31>0,MAX(0.5,’Enter Info On This Tab’!$ AZ31),”")

this will round anything below .49 to equal .50…so even 1 cent will show as 50 cents

Add your own answer in the comments!