Forum Discussion
Help with formula
I am trying to finish work for a school lab and can't figure out why my numbers don't match the answers given. I am using an IF function "=IF(A6<=0.5,60*A6,60*A6-6)". My Table looks like this: 0...
I presume that you have a typo, and the expected result for 0.50 should 30, not 3.
In that case, the formula should be:
=IF(A6<=0.5, 60*A6, 60*(A6-1))
or equivalently:
=IF(A6<=0.5, 60*A6, 60*A6-60)
Note that the second formula is the same as yours, but it corrects another typo: -60 instead of -6.