"martins" wrote in
message ...

your right - I am not being very clear - I will try to explain

If cell A1 is less than 10 then calculate the result of A3-A4 (where A4
=0) but if A1 is less than 10 but A4 is 0 then calculate A3-A4

In other words I need the result of A3-A4 where A1 is less than 10 and
A4 is 0 but also when A4 is 0 (at the moment my formula is returning
false when
A4 is 0 and what I need it to do is return the value in both
situations)

Does this help?

No it doesn't help much.

You've told us that if A1 < 10 you want the answer to be A3-A4 in the cases
where A4 =0 or A40.
You haven't told us what you want if A1=10.
You also haven't told us what you want if A1<10 and A4 <0.

Fill in the gaps in the formula below.

=IF(A1<10,IF(A4<0,"whatever you want if A1 <10 and A4 <0",A3-A4),"whatever
you want if A1 =10")
--
David Biddulph