| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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... |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If statement that does nothing when false | Excel Discussion (Misc queries) | |||
| SET statement tutorial | Excel Discussion (Misc queries) | |||
| If Statement? | Excel Discussion (Misc queries) | |||
| If statement | Excel Discussion (Misc queries) | |||
| Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
Linear Mode
