Help with formula

[vdekarski]

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.

[#2]

@vdekarski 

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.