ENGINEERING.com has updated it's forum.  To post a question please visit the new Ask@ Forum.   

With a database of over 10000 questions the library will remain available for an extended period.
Q&A


satish kumar		 In Excel can i fix the condition IfA1>40 then B1=40, If 30 View All
A1=Location of cell in MS excell sheet
B1=Location of cell in MS excell sheet
15 years ago - 2 weeks left to answer. - 1 response - Report Abuse
Respond to question
    0      [lnkReport]        0       0       
Share |
  Responses

Niel
 Did you mean

IfA1>40 then B1=40, If 30<40 B1=30, If 20<30 B1=20, If If 10<20 B1=10, If A1<10 B1=0

If so, put the following function in B1.

=IF(A1>40,40,(10*(ROUND(A1/10,0))))

The function continues the series below 0.

Niel



15 years ago

Source:


  0     0         

ENGINEERING.com does not provide engineering advice. The Ask@ service is a forum for members to exchange ideas relating to the world of engineering. We caution users not to accept any responses that they receive without further validation, and not to rely on any engineering advice that they may get from other members of the Ask@ forum. ENGINEERING.com specifically disclaims any obligation to validate or verify any information posted within the Ask@ service. ENGINEERING.com encourages users to seek the services of a professional engineer for any engineering advice they may require.