If formula reading from 2 different pieces of information.

[JChandler8314]

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.

[Glenn Kennedy]

Hi. There's a very good chance that the Forum Moderators will object to your thread title.
If so, it will HAVE to be changed. To avoid any issues and delays, maybe you should change it now.
An ideal thread title should reflect the sort of phrase that you would use if you were asking Google for an answer.

Your current title would produce a squillion useless hits.

So, it would be a good idea for you to take a moment to amend your thread title. Make sure that the title properly explains your request. To edit the thread title, open the original post, click "Edit Post" (bottom right) to access the area where you can edit your title.

Maybe something like:

"IF formula with a condition"

Also, I don't understand what AA5 has got to do with it. Please explain again... the various scenarios... the various outcomes.

[JChandler8314]

Hi,

Thanks for that and very good point! I have now changed this...

regarding the AA5+50:
If C5 does ="WASP" and F5 does = "Saturday" or "SUNDAY" then i would like the formula to calculate cell AA5+50.
If C5 does not ="WASP" and F5 does not = "Saturday" or "SUNDAY" then i would like the cell to stay blank.

Hopefully this make more sense?

[Glenn Kennedy]

Much better... on both counts.

is this it?

=IF(AND(C5="Wasp",OR(F5={"Saturday","Sunday"})),AA5+50,"")

[JChandler8314]

HI,

Thanks for the help, unfortunately it looks as though it is reading "Saturday" and "Sunday" as the same part of the formula rather than reading it as 2 separate "logical".

any ideas please?

[Glenn Kennedy]

You've lost me. Show me how it isn't working on the attached aheet. What combination gives you the wrong answer?

[JChandler8314]

Hi,

I have just used your sheet and is working fine.

I have taken all sensitive information out and created a 2 line version of the actual sheet. The formula has been entered into cell AB5. But is not working?

Could this be because Saturday and Sunday isn't manually typed in? I don't think that would matter but I'm completely stumped so clutching at straws now...

[Glenn Kennedy]

It makes all the difference in the world. It was a DATE formatted to look like the name of a day of the week.

Use this:

=IF(AND(C5="Wasp",OR(WEEKDAY(F5)={1,7})),AA5+50,"")

[JChandler8314]

wow!

It works like a dream!

Thank you very much for your help, its very much appreciated. I have added a rep for you, as that's all i can do.

Thankyou again, very impressive stuff.

[Glenn Kennedy]

You're welcome. Rep's fine as a "reward", all a bit pointless, but engenders a little competition amongst many of the solvers!!

Or, it shows you who has too much time on their hands.