when i test this formula using blank cells for c8 & g3 i get a blank cell as
a result. how is your sheet arranged?

"Andmor" wrote:

I currently have this formula =IF(C80,C8-$G$3,"") in a series of cells which
is fine when there is information but I get a # value error when there is
nothing in the cells it looks to. Is there a way to have it leave the cell
blank if there is no data in the cells it looks to?
--
A.