Forum Discussion
Solved
Functions
I am trying to set up an IF function on an excel spreadsheet, Basically in my sheet I need S2 to populate as 40 if D2=Full and E2=Yes or S2 to populate as 20 if D2=Concession and E2=Yes and remain bl...
IF(E2="Yes", IFS(D2="Full", 40, D2="Concession", 20, TRUE, ""), "")
Maybe you can use this following formula too, in cell S2 to achieve your desired result:
=IF(AND(D2="Full",E2="Yes"),40,IF(AND(D2="Concession",E2="Yes"),20,""))
This formula checks if D2 is “Full” and E2 is “Yes”.
If both conditions are true, it populates S2 with 40. If not, it checks if D2 is “Concession” and E2 is “Yes”.
If both conditions are true, it populates S2 with 20.
If neither condition is true, it remains blank.
I hope this helps! … ...and I understood it correctly 😊
- This has also worked!! Thank you, it definitely meets the requirements 🙂
