IF function

[Frankieboy]

Hi

I am looking to do an If function that if e.g. A3 = 0 then B3 = 0.0% Z, otherwise 20.0% S

So I thought this would be =IF(A3=0,''0.0% Z'',''20.0% S'')

Excel doesn't like this! So would appreciate some guidance where I am going wrong.

Thanks.

 

[sadboy309]

I think you wrong "". You try:

=IF(A3=0, " 0.0% Z ", " 20,0 % S ")

 

[Frankieboy]

Thanks but that doesn't seem to work either

 

[ClaireS]

In your formula, you are using two single-quotes '' instead of one double-quote " each side of your text strings. Once you replace these, your original code will work fine.

 

[Frankieboy]

Claire

Thank you very much for this - just couldn't figure out what was wrong!

 

[Frankieboy]

I understand your "" now Claire has put me straight. Thanks for your help!