IF STATEMENT HELP, PLEASE

Question

I have a spreadsheet where I want the IF statement to tell me if the amount is equal to or less than 80 then the result would be 100, if the amount is between 81 and 90, the answer would be 150, and if the amount is 91 or greater, the answer would be 200. How do I write the formula? Thanks!!

Answer 1

Hi Dorothy,

I see you already have an answer, but here is another approach which might be useful:

The value in A8 should be larger than any value you expect in A1.

Answer 2

Hi Dorothy Maupin,

I appreciate your kind words.

In this case, if you think my provided idea is also helpful and you can understand my explanation and correct direction on this whole scenario, could you please use the feedback tool to send us feedback? (photo below).

Your feedback really means a lot to the dedicated members of our community.

If there are any issues with Office apps in the future, feel free to post to this community again.

We will be there to help you.

Have a great day and stay safe 😊

Sincerely

Waqas Muhammad

Answer 3

Thank you I had already found my answer

Answer 4

Dear respected Dorothy Maupin,

Good day! Thank you for posting to Microsoft Community. We are happy to help you.

As per your description, let assume the amount in cell A1.

=IF(A1 <= 80, 100, IF(A1 <= 90, 150, 200))

If there is any misunderstanding, I apologize and please feel free to post back to us with more detailed information for better understanding and guiding you further.

Please understand that our initial reply may not always immediately resolve the issue. However, with your help and more detailed information, we can work together to find a solution.

I'm sorry and I apologize for that.

Appreciate your patience and understanding and thank you for your time and cooperation.

Sincerely,

Waqas Muhammad