CALCULATION BASED ON MORE THAN TWO CONDITIONS

E

Eclaires

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
 
B

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)
 
S

Sloth

=(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.
 
P

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

greater than.. 5
Move one cell to another 4
Use TODAY() function as the criteria in a SUMIF formula 1
Conditional Formatting using Formula 6
if then formula 2
conditional formatting for more than 3 conditions 3
Returning a value rather than TRUE or FALSE. 3
I need a formula 3

Top