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
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
Last edited by a moderator: