IF Statement

  • Thread starter Thread starter Sondra
  • Start date Start date
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
 
=IF(A1="","---",IF(OR(A1="ID",A1="OR"),"NO
Charge",IF(A1="NV",A3*0.6,IF(A1="CA",A3*0.9))))
 
Back
Top