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 | 0 |
| .05 | 3 |
| .1 | 6 |
| .15 | 9 |
| .2 | 12 |
| .25 | 15 |
| .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 |
| .05 | 3 |
| .1 | 6 |
| .15 | 9 |
| .2 | 12 |
| .25 | 15 |
| .3 | 18 |
| .35 | 21 |
| .4 | 24 |
| .45 | 27 |
| .5 | 3 |
| .55 | -27 |
| .6 | -24 |
| .65 | -21 |
| .7 | -18 |
| .75 | -15 |
| .8 | -12 |
| .85 | -9 |
| .9 | -6 |
| .95 | -3 |
| 1 | 0 |
I don't know why my numbers aren't matching the answers and any help would be greatly appreciated.
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.
