If Statement

[patni]

Hey guys,
I need a small help.

Cell G36 has the formulae

=O38+O39

Cell F36 has the formulae

=O32-G36

So i want to make a IF statement in cell D43,

If G36 is equal to 0 (or if cell is blank) , then i want to show blank or 0 in D43.
If G36 is not blank then, I want it to have this formulae F36/2.916

I made this formulae. But its wrong. I dont know where I am doing it wrong

=IF(G36="","",F36/2.916)

 

[DSCfromCFA]

G'day Patni

Try =IF(G36 < > 0,F36/2.916,"") Note - < & > symbols in these posts are treated like HTML commands unless they have spaces around them, you can remove the spaces.

Cheers

shane

 

[patni]

Hey DSCfromCFA,

It is working perfectly. Thank you so much for the help and time

 

[DSCfromCFA]

You're welcome, and thnaks for letting me know.

shane