Nov 10 2020 05:30 AM
Hi, I need a hand with an if statement that is not working.
In cell H9 I would like to do the following:
= If cell H4 is blank then 0 else perform the percent increase calculation (G4-C4)/C4
This is what I have:
=IF(H4=“”,0,(G4-C4)/C4)
I get a #NAME? error
Thanks, Scott
Nov 10 2020 05:44 AM
You MUST use straight quotes "" instead of curly quotes “”
Nov 10 2020 06:03 AM
@Hans Vogelaar Hi, any thoughts on how to use straight quotes? Auto correct on the Mac does not offer a way to change quote marks. Also, I just replaced the quotes by simply retyping them. I went from a #NAMES? error to a zero in the cell. But it does not change when I enter data in h9.
Nov 10 2020 06:15 AM
@scottB400 Ok, just got straight quotes. All is working, thanks, Scott