If Error

[jontyoc]

I am wanting to use the formula If(A1="","",A1-B1) in column C. I am using Excel 2007.

The values are formatted as [h]:mm:ss, and everything works fine if its false.
The sum works, however if the cell is blank I get #VALUE error.
I have tried taking off the formatting but no difference.

I have used this on other spreadsheets with no bother and its getting me slightly perplexed.
Have tried the opposite formula too - IF(A1<>"",A1-B1,"")

Any help greatly appreciated.

 

[Robert Mika]

Is the cell empty or have text or " " space?
If one of the above you will get this error.
Same if A1= Text
Text- number =Error

Try this:
=IF(ISTEXT(A1),"",A1-B1)

 

[jontyoc]

HI Robert
The cell will be blank. not with any text or spaces.

 

[BeingYogi]

See if this Solves

IF(OR(A1="",A1<B1),"",A1-B1)

 

[jontyoc]

All fixed now. Ive gone back and started from scratch.
Now working with =IF(ISTEXT(A1),"",A1-B1)

Thanks Robert and BeingYogi for help