Thread: IF Statement
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sondra Sondra is offline
external usenet poster
 
Posts: 12
Default 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