CALCULATION BASED ON MORE THAN TWO CONDITIONS

[Guest]

Please would someone help me again?

I need to come up with a value in one cell dependent on conditions being met
or not met in another.

eg: if value in A1 is zero return value in A2 as zero, but if value in A1 is
greater than zero but less than 240 return a value of 240, however if value
in A1 is over 240 return whatever value it is in A2.

Hope this makes sense.

Kind regards


Eclaires

 

[PCLIVE]

Maybe this?

=IF(A1=0,0,IF(A1<240,240,A2))

HTH,
Paul

 

[Bob Phillips]

I think you mean

=IF(A1=0,0,IF(A1<240,240,A1))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

=(A1<>0)*MAX(240,A1)

Generally the answer is the classic if, then, else and nested ifs that has
already been given. However, many people dislike nested ifs (myself
included), because they are hard to follow. Of course it is a matter of
opinion which route to choose.

 

[PCLIVE]

Yes. That is what I had at first but got confused at the way the request
was written. I thing you're correct though.
Thanks.