IF STATEMENT
 

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

IF STATEMENT
 

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:

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

IF STATEMENT
 

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})


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=556149

IF STATEMENT
 

THANKS!

"Marcelo" wrote:

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:

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

IF STATEMENT
 

thanks for the feedback


"JK" escreveu:

THANKS!

"Marcelo" wrote:

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:

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