| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Statement
I need to create an IF Statement that covers all the following:
If State=ID or OR field should say "NO CHARGE" If State=NV multiple field A3 * 6% If State=CA multiple field A3 * 9% If State is empty field should show --- Thanks in advance |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Statement
=IF(A1="","---",IF(OR(A1="ID",A1="OR"),"NO
Charge",IF(A1="NV",A3*0.6,IF(A1="CA",A3*0.9)))) -- If this post helps click Yes --------------- Jacob Skaria "Sondra" wrote: I need to create an IF Statement that covers all the following: If State=ID or OR field should say "NO CHARGE" If State=NV multiple field A3 * 6% If State=CA multiple field A3 * 9% If State is empty field should show --- Thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
| Sum if statement with a left statement | Excel Discussion (Misc queries) | |||
| SUMIF statement with AND statement | Excel Discussion (Misc queries) | |||
| Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
Linear Mode
