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

# Excel Formula help nesting

**roadworker**#2

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

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

**roadworker**#4

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…