Help with Formula

[martins]

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

Please help

[Dav]

First of all 0 is returned as text in your formula if you want it as a 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 right answer

Regards

Dav

[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").

In article <[email protected]>,
martins <[email protected]> wrote:

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

[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]

"martins" <[email protected]> wrote in
message news:[email protected]...
>
> 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")
--
David Biddulph

[Brad]

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


"martins" wrote:

>
> 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?
>
>
> --
> martins
> ------------------------------------------------------------------------
> martins's Profile: http://www.excelforum.com/member.php...o&userid=31616
> View this thread: http://www.excelforum.com/showthread...hreadid=562380
>
>