| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show "+" (plus) sign when comparing two values
Dear Excel experts,
I am comparing the values of cells in two columns: if difference B1-A1 is <0, then the minus sign logically appears before the value. But how can I make a "+" sign appear when difference B1-A1 0? A thousand of thanks for your help! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Show "+" (plus) sign when comparing two values
Try
=IF(B1-A10,"+"&B1-A1,B1-A1) -- Regards Warren Excel Novice Addiewell, Scotland. If this helps please click the Yes button. "filpass" wrote: Dear Excel experts, I am comparing the values of cells in two columns: if difference B1-A1 is <0, then the minus sign logically appears before the value. But how can I make a "+" sign appear when difference B1-A1 0? A thousand of thanks for your help! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Show "+" (plus) sign when comparing two values
Hi,
Apply a custom format of +0;-0;0 Mike "filpass" wrote: Dear Excel experts, I am comparing the values of cells in two columns: if difference B1-A1 is <0, then the minus sign logically appears before the value. But how can I make a "+" sign appear when difference B1-A1 0? A thousand of thanks for your help! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Show "+" (plus) sign when comparing two values
Dear Mike,
you again saved my day:) Thanks! "Mike H" wrote: Hi, Apply a custom format of +0;-0;0 Mike "filpass" wrote: Dear Excel experts, I am comparing the values of cells in two columns: if difference B1-A1 is <0, then the minus sign logically appears before the value. But how can I make a "+" sign appear when difference B1-A1 0? A thousand of thanks for your help! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Show "+" (plus) sign when comparing two values
Hi warren,
While your method works to an extent I wouldn't use it because it can cause problems with logical comparisons. Try my formatting method in c1 and your method in d1 then do a logical compare back to the 2 original numbers in a1 & b1 Your method in d1 evaluates as false =D1=B1-A1 The format method in c1 evaluates as true =C1=B1-A1 Mike "Warren Easton" wrote: Try =IF(B1-A10,"+"&B1-A1,B1-A1) -- Regards Warren Excel Novice Addiewell, Scotland. If this helps please click the Yes button. "filpass" wrote: Dear Excel experts, I am comparing the values of cells in two columns: if difference B1-A1 is <0, then the minus sign logically appears before the value. But how can I make a "+" sign appear when difference B1-A1 0? A thousand of thanks for your help! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Show "+" (plus) sign when comparing two values
Thanks a lot Warren!
It works perfectly. Enjoy a great day! Filippo "Warren Easton" wrote: Try =IF(B1-A10,"+"&B1-A1,B1-A1) -- Regards Warren Excel Novice Addiewell, Scotland. If this helps please click the Yes button. "filpass" wrote: Dear Excel experts, I am comparing the values of cells in two columns: if difference B1-A1 is <0, then the minus sign logically appears before the value. But how can I make a "+" sign appear when difference B1-A1 0? A thousand of thanks for your help! |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Show "+" (plus) sign when comparing two values
Glad I could help and thanks for the feedback
"filpass" wrote: Dear Mike, you again saved my day:) Thanks! "Mike H" wrote: Hi, Apply a custom format of +0;-0;0 Mike "filpass" wrote: Dear Excel experts, I am comparing the values of cells in two columns: if difference B1-A1 is <0, then the minus sign logically appears before the value. But how can I make a "+" sign appear when difference B1-A1 0? A thousand of thanks for your help! |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Show "+" (plus) sign when comparing two values
Thank You for the Feedback
-- Regards Warren Excel Novice Addiewell, Scotland. If this helps please click the Yes button. "filpass" wrote: Thanks a lot Warren! It works perfectly. Enjoy a great day! Filippo "Warren Easton" wrote: Try =IF(B1-A10,"+"&B1-A1,B1-A1) -- Regards Warren Excel Novice Addiewell, Scotland. If this helps please click the Yes button. "filpass" wrote: Dear Excel experts, I am comparing the values of cells in two columns: if difference B1-A1 is <0, then the minus sign logically appears before the value. But how can I make a "+" sign appear when difference B1-A1 0? A thousand of thanks for your help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find "Look in" box does not show 'values' on 'formulas' | Excel Worksheet Functions | |||
| How to "sign" macro with "digital certificate"? | New Users to Excel | |||
| How do display a "+" or "-" sign when hiding columns? | Setting up and Configuration of Excel | |||
| conditional formula to show "open" or "closed" | Excel Worksheet Functions | |||
| Changing "returned" values from "0" to "blank" | Excel Worksheet Functions | |||
Linear Mode
