Forum Discussion
Solved
Help with IF Conditional formatting
Hi I am not an excel expert so pardon if my question sounds confusing. I am trying to set multiple conditions using free text as validation and want to build a formula to calculate. Here is what I di...
Keeping the same logic as what you stated with, try this:
=IF(M11>="TJO",D5+45,IF(M11>="RfR",D5+60,IF(M11>="PJSO",D5+120, "")))
No need for the AND bits and you need the check the texts in descending alphabetical order.
Edit: And no need for the quotation marks and the = sign where you want to perform a calculation as it just creates a text like =D5+60 as you discovered.
Keeping the same logic as what you stated with, try this:
=IF(M11>="TJO",D5+45,IF(M11>="RfR",D5+60,IF(M11>="PJSO",D5+120, "")))
No need for the AND bits and you need the check the texts in descending alphabetical order.
Edit: And no need for the quotation marks and the = sign where you want to perform a calculation as it just creates a text like =D5+60 as you discovered.
Hi Riny_van_Eekelen, thanks for the swift and BRILLIANT response! Yes, Yes, Yes! It worked! Ha! We live and learn from each other! This was my first experience reaching out on a forum like this with a question and my experience has been SUPER! Many thanks again!!!