M
mlv
I have a formula that puts a currency value in a cell (assume A1).
That value can be anything from £0.00 upwards.
Dependent on other factors, if the calculated value of Cell A1 is £0.00
(zero pounds), the formula may enter £0.00, or it may leave the cell blank
(i.e. using value "" in the formula).
An adjacent cell (assume B1) has to perform a calculation on Cell A1 only if
the value of Cell A1 is greater than £0.00 (i.e. £0.01 and upwards).
I was trying the formula:
=IF(A1>0,ROUND((D6/(100-N6)*N6),2),"")
The formula works fine when Cell A1 is £0.00 (Cell B1 shows blank) or when
Cell A1 shows a value above £0.00 (Cell B1 shows the calculated value).
However, the formula fails when A1 is blank and I get the #VALUE! error.
Doesn't the formula =IF(A1>0, ... return 'False' when Cell A1 is blank?
How else can I easily check Cell A1 for 'not blank' AND 'greater then zero'?
Thanks
That value can be anything from £0.00 upwards.
Dependent on other factors, if the calculated value of Cell A1 is £0.00
(zero pounds), the formula may enter £0.00, or it may leave the cell blank
(i.e. using value "" in the formula).
An adjacent cell (assume B1) has to perform a calculation on Cell A1 only if
the value of Cell A1 is greater than £0.00 (i.e. £0.01 and upwards).
I was trying the formula:
=IF(A1>0,ROUND((D6/(100-N6)*N6),2),"")
The formula works fine when Cell A1 is £0.00 (Cell B1 shows blank) or when
Cell A1 shows a value above £0.00 (Cell B1 shows the calculated value).
However, the formula fails when A1 is blank and I get the #VALUE! error.
Doesn't the formula =IF(A1>0, ... return 'False' when Cell A1 is blank?
How else can I easily check Cell A1 for 'not blank' AND 'greater then zero'?
Thanks