IF/THEN help

Question

I need to write a simple IF/THEN formula that goes like thisa: IF the value in a cell is 1, then target cell displays $325, and if the value of the cel (same cell) is 2, the target cell displays $375. Not great with logic formulas, I'm sure it's easy, anyone can help?

Answer 1

Hi MTMCH,

Thanks for your valuable feedback and sharing updates with us and I really appreciate your effort and your precious time doing. 

And I appreciate your kind words.

As per your screenshot, it looks the value 1 is no stored in cell as a number (its look cell formated in Tex format) your "numbers" seem be texts. Please format the cell as Number format.

Your understanding and patience will be highly appreciated. I hope that you are keeping safe and well!

Sincerely,

Waqas Muhammad

Answer 2

Hi MTMCH,

You are welcome:) If possible, could you please also give feedback on it.

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 so much, sir, that fixed it!

Answer 4

Thank your for your quick reply, but that didn't quite work for me. The cell remains blank after I enter in the formula.

Answer 5

Dear respected MTMCH,

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

As per your description,

=IF(A1=1, 325, IF(A1=2, 375, ""))

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