Thread: IF STATEMENT
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo
 
Posts: n/a
Default 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...