So i have an IF formula that for some reason i cannot get my head around.
I have information in cell C5 and a day in F5.
I would like the formula to read if cell C5="WASP" and F5="SATURDAY" or "SUNDAY" then AA5+50. If C5 does not contain "WASP" or it is not a weekend day shown in F5 then i would like it to stay blank. I have tried many different ways, but cannot get it to work!
Any help would be much appreciated.
Bookmarks