Hi all

just after a quick fix (and probably a very simple one too, lol)

I want a cell to display 0 if a different cell is less than a given
value (in this case 95). One of the issues i face is that the cell i
want to display as 0 (in the above instance) is needing a calculation
in there.

b4 = the cell which will determine the outcome, less than 95=0 in cell
b10
b5 = value
b9 = value
b10 = b5+b9 currently (but should display 0 if b4 is less than 0)

All help appreciated :)

yY