Excel Formula help nesting


=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 :slight_smile:



Thanks! It was the semicolon I was missing. Thanks again!


Glad I could help… :wink:
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… :wink: