IF STATEMENT

[Guest]

This is what I'm trying to do...

IF
A2 IS EQUAL TO 8 THEN DISPLAY 228.0 IN A3
A2 IS EQUAL TO 10 THEN DISPLAY 182.4 IN A3
A2 IS EQUAL TO 12 THEN DISPLAY 152.0 IN A3
A2 IS EQUAL TO 16 THEN DISPLAY 114.0 IN A3
A2 IS EQUAL TO 20 THEN DISPLAY 91.2 IN A3
A2 IS EQUAL TO 24 THEN DISPLAY 76.0 IN A3

Could someone show me easiest way to do this?
Much appreciated...

 

[Guest]

Hi

=IF(A2=8,228,IF(A2=10,182.4,IF(A2=12,152,IF(A2=16,114,IF(A2=20,91.2,IF(A2=24,76,FALSE))))))

HTH
regards from Brazil
Marcelo

"JK" escreveu:

 

[Bearacade]

You can:

1) Use vlookup

2) Use if:

=IF(A2=8,228,IF(A2=10,182.4,IF(A2=12,152,IF(A2=16,114,IF(A2=20,91.2,IF(A2=24,76,"Out
of Range"))))))

3) Use lookup:

=LOOKUP(A2, {8,10,12,16,20,24;228,182.4,152,114,91.2,76})

 

[Guest]

THANKS!

Hi

=IF(A2=8,228,IF(A2=10,182.4,IF(A2=12,152,IF(A2=16,114,IF(A2=20,91.2,IF(A2=24,76,FALSE))))))

HTH
regards from Brazil
Marcelo

"JK" escreveu:

 

[Guest]

thanks for the feedback


"JK" escreveu:

THANKS!