Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF statement does not work with "=" sign
I have a simple if statement:
=IF(B42=B44,"Balanced","Not Balanced") B42 and B44 are exactly the same dollar amount but it says "not balanced". Both b42 and b44 are formatted as dollar amounts. The cell in question with this statement is formatted as 'general'. I tried using other cells etc. I used a 'watch' window and it stated the values of B42 and B44 as the same. Thanks Bill |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF statement does not work with "=" sign
They may appear the same but if they have been calculated they not match
exactly. If they are dollar amounts (no cents) try: If (int(b42)=int(b44),"Balanced","Not balanced") or If (Round(b42,0)=round((b44,0),"Balanced","Not balanced") If cents required, multiply by 100. HTH "BBinSimi" wrote: I have a simple if statement: =IF(B42=B44,"Balanced","Not Balanced") B42 and B44 are exactly the same dollar amount but it says "not balanced". Both b42 and b44 are formatted as dollar amounts. The cell in question with this statement is formatted as 'general'. I tried using other cells etc. I used a 'watch' window and it stated the values of B42 and B44 as the same. Thanks Bill |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF statement does not work with "=" sign
If a dollar amount, more probably
=If (Round(b42,2)=round((b44,2),"Balanced","Not balanced") -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Toppers" wrote in message ... They may appear the same but if they have been calculated they not match exactly. If they are dollar amounts (no cents) try: If (int(b42)=int(b44),"Balanced","Not balanced") or If (Round(b42,0)=round((b44,0),"Balanced","Not balanced") If cents required, multiply by 100. HTH "BBinSimi" wrote: I have a simple if statement: =IF(B42=B44,"Balanced","Not Balanced") B42 and B44 are exactly the same dollar amount but it says "not balanced". Both b42 and b44 are formatted as dollar amounts. The cell in question with this statement is formatted as 'general'. I tried using other cells etc. I used a 'watch' window and it stated the values of B42 and B44 as the same. Thanks Bill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If statement | Excel Discussion (Misc queries) | |||
dates and if statement work on one sheet, not on another | Excel Worksheet Functions | |||
Linking with equals sign doesn't always work | Excel Worksheet Functions | |||
# sign in a cell | Excel Discussion (Misc queries) | |||
Work book formulas | Excel Discussion (Misc queries) |