Calculate based on Day of week?

[Utradeshow]

Hi All,

I have been trying to figure out a formula that has 3 criteria,

A1 = FRIDAY
A2 = MONDAY
A3 > 500

A4 result would be an additional $250.00

I can do it multiple formulas, but I am trying to combine into one formula.

Thank you

 

[KennyGreens]

Maybe I am misunderstanding, but what exactly are you trying to do?

 

[Joe4]

I definitely think we need more information. It is not clear the logic behind what is supposed to be happening.

Please describe the logic in plain English, and walk us through a few examples.

 

[Utradeshow]

Hi All,

I have been trying to figure out a formula that has 3 criteria,

A1 = FRIDAY
A2 = MONDAY
A3 > 500

A4 result would be an additional $250.00

I can do it multiple formulas, but I am trying to combine into one formula.

Thank you

Sorry, I do see it's unclear now that I read it... I am trying to say is
IF cell A1's value is Friday or 6 using weekday function
AND cell A2 is Monday or 2 using weekday function
AND cell A3's value is less than 500
then the result in cell A4 would be $250.00

 

[Joe4]

then the result in cell A4 would be $250.00

How is $250 determined to be the number?
What is the logic behind arriving at that value?