Adding to or adjusting a formula

[bionicle]

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

 

[Special-K99]

Is that your actual formula?
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.

 

[bionicle]

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.

 

[Fluff]

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.

 

[bionicle]

that works a treat, thank you very much..

 

[Fluff]

You're welcome & thanks for the feedback