I have a problem. I've tried multiple functions, with no success.
A1 can have any number entered.
B1 has a drop box, with a choice of "Yes" or "No".
C1 needs a function to generate pre-determined answers using responses from A1 & B1.
Info:
If A1<=8, and B1="No", then C1=20;
If A1<=8, and B1="Yes", then C1=40;
If A1>8, and B1="No", then C1=40; and
If A1>8, and B1="Yes", then C1=40.
I appreciate all help. Thanks!
Bookmarks