IF Statement

S

Sondra

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
 
J

Jacob Skaria

=IF(A1="","---",IF(OR(A1="ID",A1="OR"),"NO
Charge",IF(A1="NV",A3*0.6,IF(A1="CA",A3*0.9))))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countif - problem counting text, other text 1
Page numbering with Merged Document and IF statements 1
Insert Multiple Fields without Dialog closing between each... 0
Convert State abbreviations color coded cell 9
Help with determining instructor class location. 0
Auto Fill Word Documents 4
Copy previous record into form field 0
Tracked changes by multiple people modified to one 0

Top