Is it possible to write an IF statement (or other type of formula) where you are comparing two numbers and you want to make sure the whole numbers are correct but you don't care about what's after the decimals?
Example:
In A1= 21.05556
In A2= 21.15
Is it possible to write a formula that basically states A1=A2 (or if A1=A2 then 'correct') in the example above?
=IF ( INT(A1)=INT(A2), "Correct", "NOT Correct")
INT just takes the bit before the decimal Integer
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Beautiful, that worked.
you are welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks