Hi Experts
I am looking for a formula that will give me the result as true or false, If condition met
Plz see the sample file
Hi Experts
I am looking for a formula that will give me the result as true or false, If condition met
Plz see the sample file
Maybecopied downFormula:Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Sorry TMS Sir but after putting formula i am not getting the desired output
plz put the formula in the sample file and see the output
Try:
=OR(INT(A1)=INT(B1),INT(A1)=INT(C1))
Quang PT
You don't say so anywhere but it looks like you are comparing just the integer part for testing equality, not any fractional part. There is not enough sample data to determine whether I should be truncating to integer or rounding, but the following mod or TMS's formula works with your 3 test cases:
Formula:Please Login or Register to view this content.
Geoff
Did I help significantly? If you wish, click on * Add Reputation to say thanks.
If your problem has been resolved please select ?Solved? from the Thread Tools menu
Problem Solved
Thnx Alot TMS, Bebo021999, GeoffW283 for helping me in solving this problem Sir
Have a Awesome Day
You too. Thanks for the feedback.Have a Awesome Day
You're welcome. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks