Help with formula

Occasional Visitor

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:

00
.053
.16
.159
.212
.2515
.318

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.

1 Reply

@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.

 

JoeUser_0-1664172878634.png