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 blank if E2 is blank. S2 is the Value, D2 is membership Fee type and E2 is confirmation whether the qtr paid in advance.
I'm an untrained novice with excel and anything I can do is learn through trial and error and googling, I'm failing to find anything online that will allow me to complete the above so not sure if this is even possible.
Any help is much appreciated, even if it is to give up.
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 🙂
IF(E2="Yes", IFS(D2="Full", 40, D2="Concession", 20, TRUE, ""), "")
- This has worked brilliantly thank you
