Excel IF formula

[scottB400]

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

[#2]

@scottB400 

You MUST use straight quotes "" instead of curly quotes “”

[#3]

@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.

[#4]

@scottB400 Ok, just got straight quotes. All is working, thanks, Scott