Microsoft Office Forums - View Single Post - Cell with unresolved formula in has value > 0

Thread: Cell with unresolved formula in has value > 0

View Single Post

Old

07-03-2014, 02:19 AM

Bobby

Bobby is offline

Bobby uses Windows 7 64bit

Windows 7 64bit Bobby uses Office 2007

Bobby uses Office 2007

Office 2007

Novice

The original poster

Join Date: Jul 2014

Posts: 2

Bobby is on a distinguished road

Default

Cell with unresolved formula in has value > 0

Hi,

I have a sheet with =IF(B5<0,(B5*-1)/D5*F4,"") in cell H5.

There is no data in the sheet at all, and cell H5 shows as blank.

If I try and construct a formula starting If H5>0 then it shows as true.

Surely a cell with no value is not > 0?

Reply With Quote