Iserror ?

[VegasL]

How would I use the iserror function with this formula? =IF(O8,O8-G8,"")


Basically, the formula currently works, but when there is no value in column 0, i am getting a #VALUE! error, which I dont want. If there is no value in column 0, i want it to return an empty space, which I thought could be accomplised with "".


Anyhow, how could I incorporate iserror into above?

[VegasL]

Never mind figured it out. it's =IF(ISERROR(O8-G8),"",O8-G8)