Excel Formula help nesting


#1

=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.


#2

I dunno if the formatting in English is the same,as we use a localization for ‘IF’,but you can try this :slight_smile:

=IF(B15=0;"";IF(B15>0;C15*D15))


#3

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


#4

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: