=IF(B15=“0”,""),IF(B15>“0”,“C15*D15”) I am trying to return a zero if nothing in column b and if a number higher than zero then multiply c X d. I keep getting errors.
I dunno if the formatting in English is the same,as we use a localization for ‘IF’,but you can try this
Thanks! It was the semicolon I was missing. Thanks again!
Glad I could help…
FYI,when using nested formulas,you always need to have the extra semicolon @ the end of the formula.
In normal circumstances,you can only nest up to 7 IF statements,but here you can find a way to circumvent that limit…