Syntax HELP

[Eric H]

I know this is wrong...
=if(G40>0,G40*$G$36,""),or(if(I40>0,I40*$I$36,"")or(if(K40>0,K40*K36,"")


but what is the correct way to write an IF,OR statement?

 

[Fred Smith]

It doesn't look to me like you want an Or condition. You want nested Ifs, as
in:
=if(G40>0,G40*$G$36,if(I40>0,I40*$I$36,if(K40>0,K40*K36,"")))

Regards,
Fred.

 

[Don Guillett]

Depends on what you want. This checks g40 and if >0,g40*g36. If not then
checks i40 and then checks k40.
Is this what you want?
=IF(G40>0,G40*G36,IF(I40>0,I40*I36,IF(K40>0,K40*K36,"")))

 

[Eric H]

Thanks to all. It was helpful and got me on my way.