Excel Formula [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
in a separate cell, i have a number. If that number is greater than 11, i want a certain entry. if that cell is >6<11, i want another entry and if that cell is <6 i want a different entry. How would that formula look?

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
766
=IF(A1>11, "a1 is greater than 11", if(a1>6, "a1 is greater than 6 but less or equal to 11, "default so a1 must be less than or equal to 6"))

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!