Hi All,
Need some help please, I have the following formula thatworks as it should so no problem there however I’m trying to amend it or add a secondformula to the front of it so that the formula returns a value of zero based onspecific text in the cell C2 (house).
The working formula as it is will return a value based onthe calculation of cell V32 which can range from 500 to 100,000
=IF((\$V32+\$W32+SUMPRODUCT(\$Z\$21:\$AF\$21,\$Z32:\$AF32))< data!\$o\$13,0,((\$v32+\$w32+sumproduct(\$z\$21:\$af\$21,\$z32:\$af32))-data!\$o\$13)*data!\$o\$16)
Any help would be fab.

Steve

Looks odd to me.

Does it contain < > characters?
The forum often displays posts with < > characters incorrectly.
To get round this places spaces around the < > characters.

formula is correct and calculates correctly. I want to add something like =IF(AND(C32="House"),"0")

when I add this to the formula I don't get the correct value out
=IF(AND(C32="house"),"0",0)&IF((\$V32+\$W32+SUMPRODUCT(\$Z\$21:\$AF\$21,\$Z32:\$AF32))< data!\$o\$13,0,((\$v32+\$w32+sumproduct(\$z\$21:\$af\$21,\$z32:\$af32))-data!\$o\$13)*data!\$o\$16)

When I add the word house to cell c32 it should return a 0any other value should return a the exact figure that I have prior to addingthe additional formula but nothing works for me.

Try
=IF(C32="house",0,IF((\$V32+\$W32+SUMPRODUCT(\$Z\$21:\$AF\$21,\$Z32:\$AF32))< data!\$o\$13,0,((\$v32+\$w32+sumproduct(\$z\$21:\$af\$21,\$z32:\$af32))-data!\$o\$13)*data!\$o\$16))

Also please note what Special-K99 said about putting spaces around the < & > signs in formulae.
I have corrected both your posts.

that works a treat, thank you very much..

You're welcome & thanks for the feedback