Help with Formula

[martins]

I have the formula =if(A1<10,"0",A3-A4) however, what would the formul
look like if I wanted to add in a comparison to calculate the resul
where cell
A4 is >0 - is this an and/or scenario?

Please hel

 

[Dav]

First of all 0 is returned as text in your formula if you want it as
number loose the " "


You need to tell us your situations


If a1<0
else if a4>0

or if a1<0 and a4>0

Explain it clearly in english and then someone will give you the righ
answer

Regards

Da

 

[JE McGimpsey]

One way:

=IF(AND(A1<10,A4>0),0,A3-A4)

(This assumes you want the value 0 rather than the text character "0").

 

[martins]

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?

 

[David Biddulph]

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 A4>0.
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")

 

[Guest]

Is this what you are looking for
=IF((A1<10),0,A3-max(0,A4))