LinkBack URL
About LinkBacks
hi
based on this if statement, i should get False instead of True.
=IF(A4=A3,D4="P",D3="U")
APRU 5072479 20/09/2008 07:44:04 KR07/47-4 U Y TRUE
APRU 5073285 17/09/2008 20:37:48 KP12/30-3 U O TRUE
whats went wrong ??
hi
based on this if statement, i should get False instead of True.
=IF(A4=A3,D4="P",D3="U")
APRU 5072479 20/09/2008 07:44:04 KR07/47-4 U Y TRUE
APRU 5073285 17/09/2008 20:37:48 KP12/30-3 U O TRUE
whats went wrong ??
You can not have a formula in column F changing a non formula entry in column D
try
=IF(A4=A3,TRUE,FALSE)
Last edited by mudraker; 10-30-2008 at 07:27 AM.
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assistedor failed to assist you
I welcome your Feedback.
All 3 of those arguments are conditions that return TRUE/FALSE
So if Condition 1 is True, it will check the 2nd Condition and return TRUE/FALSE...
if Condition 1 is False, it will check the 3rd condition and return TRUE/FALSE...
In your case above, Condition 1 is FALSE, so it Checks the 3rd argument (ie. D3="U") which it does, so you get TRUE back.
What is it you really need?
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
NBVC,
i need to check all the 3 conditions must be true to be valid, guess im wrong with the if statement.
Last edited by okl; 10-30-2008 at 07:44 AM.
How about
=IF(AND(A3=A2,D3="P",D2="U"),TRUE,FALSE)
Ed
_____________________________
Always learning, but never enough!
_____________________________
If you are wanting TRUE/FALSE results, then there is no need to use the IF() statement.Originally Posted by EdMac
Point taken, thanks NBVC
Try:
=AND(A4=A3,D4="P",D3="U")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks