ExcelBanter - IF Statement

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - IF Statement (https://www.excelbanter.com/excel-worksheet-functions/230008-if-statement.html)

Sondra

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

Jacob Skaria

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

All times are GMT +1. The time now is 08:52 PM.