Forum Discussion
Ieuano1995
Mar 28, 2023Copper Contributor
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...
- Mar 28, 2023
IF(E2="Yes", IFS(D2="Full", 40, D2="Concession", 20, TRUE, ""), "")
HansVogelaar
Mar 28, 2023MVP
IF(E2="Yes", IFS(D2="Full", 40, D2="Concession", 20, TRUE, ""), "")
Ieuano1995
Mar 28, 2023Copper Contributor
This has worked brilliantly thank you