Syntax HELP

  • Thread starter Thread starter Eric H
  • Start date Start date
E

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?
 
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.
 
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,"")))
 
Back
Top