Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula to show + or - before the result of an existing formula
I need a formula that will display + or - in front of the value of my current
formula. B4=7.5 B3=6.5 I want the result to display +15% or - if that were applicable. Right now it just displays the whole # if positive and nothing if negative. What I have =IF(B4/B3-100%0,B4/B3-100%,"") |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula to show + or - before the result of an existing formula
I need a formula that will display + or - in front of the value of my
current formula. B4=7.5 B3=6.5 I want the result to display +15% or - if that were applicable. One way is to use two steps. First, use the formula: =IF(B3=0,"-",B4/B3-100%) (Notice the added check for dividing by zero.) Second, select the cell holding the formula and use: Format Cells Number Custom and in the Type field put +0%;-0% |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula to show + or - before the result of an existing formul
First, use the formula:
=IF(B3=0,"-",B4/B3-100%) (Notice the added check for dividing by zero.) Second, select the cell holding the formula and use: Format Cells Number Custom and in the Type field put +0%;-0% One thing I left out. This is an ongoing chart that I'm inputting data in periodically and the premade graph updates as I go. With the new formula, my result now displays -100% for the cells that I haven't entered in any data for yet. ... can the result still display nothing with no data in cell B4? One way: =IF(OR(B3=0,B4=""),"",B4/B3-100%) but you probably figured out something like that already. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula to show + or - before the result of an existing formul
Thak you very much. I did figure it out. Thaks for your help.
"MyVeryOwnSelf" wrote: First, use the formula: =IF(B3=0,"-",B4/B3-100%) (Notice the added check for dividing by zero.) Second, select the cell holding the formula and use: Format Cells Number Custom and in the Type field put +0%;-0% One thing I left out. This is an ongoing chart that I'm inputting data in periodically and the premade graph updates as I go. With the new formula, my result now displays -100% for the cells that I haven't entered in any data for yet. ... can the result still display nothing with no data in cell B4? One way: =IF(OR(B3=0,B4=""),"",B4/B3-100%) but you probably figured out something like that already. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cells show formula like in formula bar, rather than result of form | Excel Discussion (Misc queries) | |||
Why does the formula show instead of the result? | Excel Discussion (Misc queries) | |||
Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
My formula will not show the result, only the formula. | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |