Combine another Excel Formula
Hello Experts,
Can someone assist me in combining the following formulas into one formula?
=IF(AND(AND(F21>C21),AND(B
and
=IF(AND(AND(Q21<N21),AND(B
Cheers
Carlton
Can someone assist me in combining the following formulas into one formula?
=IF(AND(AND(F21>C21),AND(B
and
=IF(AND(AND(Q21<N21),AND(B
Cheers
Carlton
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Francis Omoruto
@nutsch, brilliantly done!
ASKER
nutsch
I need the second formula.
Going to test it now....
In the meantime, cheers mate...
I need the second formula.
Going to test it now....
In the meantime, cheers mate...
ASKER
nutsch
On the face of it, it appears to work. However, it gives me the a TRUE or FALSE answer, whereby the last part of the formula should just give me the value of the cell.
For example, if cell B21 is MSFT, if =if(OR(and(f21>C21,BL21>BM
I hope that makes sense.
Cheers
On the face of it, it appears to work. However, it gives me the a TRUE or FALSE answer, whereby the last part of the formula should just give me the value of the cell.
For example, if cell B21 is MSFT, if =if(OR(and(f21>C21,BL21>BM
I hope that makes sense.
Cheers
I get the right result when I test. Check screencast
I've just tested and it works fine for me without any changes!
Please re-check the formula you have typed in.
Please re-check the formula you have typed in.
ASKER
nutsch,
Pretty impressive screencast.
Anyway, I typed in the following formula
=IF(OR(AND(F21>C21,BL21>BM
Pretty impressive screencast.
Anyway, I typed in the following formula
=IF(OR(AND(F21>C21,BL21>BM
ASKER
I curious as to why I get a TRUE statement, rather than the value in cell B21???
Clear any formats from the cell containing the formula...
ASKER
nutsch
I have attached my spreadsheet. At this stage, I have only applied your formula to cell BU21.
You'll see what I mean.
Cheers
EE-IB-Brokersv5.xlsm
I have attached my spreadsheet. At this stage, I have only applied your formula to cell BU21.
You'll see what I mean.
Cheers
EE-IB-Brokersv5.xlsm
Very strange!
If I type the formula into BY21 and then copy it back to BU21, it works.
Curious!
No, I haven't figured out why it is so yet.
If I type the formula into BY21 and then copy it back to BU21, it works.
Curious!
No, I haven't figured out why it is so yet.
ASKER
Ahhhhhhhhh, so I wasn't going crazy :-)
Its really weird how it worked for you and nutsch.....
Its really weird how it worked for you and nutsch.....
ASKER
Anyway, I hope you continue to check it out for me, I've really must get some sleep zzzzzz
I'll be up for about another 20 mins if you have any questions.
Cheers
So, just try the formula in any other blank cell that you haven't touched before and see if you get the right result.
When you do, copy the formula via the formula bar, rather than just pasting it on the cell.
Time to catch forty winks!
When you do, copy the formula via the formula bar, rather than just pasting it on the cell.
Time to catch forty winks!
You have entered the formula twice. Just delete the duplicate.
But you shouldn't be giving points for this. The formula was all Thomas's
Thomas' formula should get all the points. Was there a different suggestion?
ASKER
Will someone please promote this guy, freakin genius!
Cheers man
Cheers man