Calculation based on criterias..

Question

Calculation based on criterias..

Chaturvedi, Santosh 430

Hello I want to caculate if the conditions applies as shown below.. How to mmake formulation with 2 condtions.

IFS(B7>C7," calculate with this formuala (1/(1-$B$2)", and

if C7>B7, calculate with this formula "1/(1+($G$70*(D701/C701)")

Please help me in this regard

0 comments

Answer accepted by question author

0 additional answers

Your answer

Answer 1

Hi @Chaturvedi, Santosh,

Thank you for posting your question in the Microsoft Q&A forum.

Based on your description, you'd like to apply two conditions in a single formula one when B7 > C7, and another when C7 > B7. For this scenario, you can try the formula below:

=IF(B7>C7, 1/(1-$B$2), IF(C7>B7, 1/(1+($G$70*(D701/C701))), ""))

This formula evaluates the first condition; if it's not met, it checks the second one. If neither condition applies (for example, when B7 = C7), it will return a blank cell.

Could you please confirm whether my understanding of your situation is correct? If I've misinterpreted any part, feel free to clarify. I want to make sure I fully understand your setup so I can provide the most accurate guidance.

If possible, could you also share a screenshot of what you're trying to calculate? (Feel free to hide any sensitive information.) That would help me get a clearer picture of your data layout.

Thank you again for your time and patience. I really appreciate it, and I'm here to help. Looking forward to your response.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".     

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread   