# Help with formula

Occasional Visitor

# 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 0 0.05 3 0.1 6 0.15 9 0.2 12 0.25 15 0.3 18

This continues until the left side reaches "1" and the right side reaches "54"

The issue is that the correct table should look like this:

 0 0 0.05 3 0.1 6 0.15 9 0.2 12 0.25 15 0.3 18 0.35 21 0.4 24 0.45 27 0.5 3 0.55 -27 0.6 -24 0.65 -21 0.7 -18 0.75 -15 0.8 -12 0.85 -9 0.9 -6 0.95 -3 1 0

I don't know why my numbers aren't matching the answers and any help would be greatly appreciated.

# Re: Help with formula

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.