# IF cell is positive help

#### nymyth

##### Board Regular
I have a little problem and was wondering if someone can help me out.

I am working on an Income Statement where I show:

Actuals Budget CM Act vs CM Bud(\$) CM Act vs CM Bud (%)

The problem is in the final column for the %. The percentage formula says "If ROUND of column C is 1, then give me a 0%, else divide column C and B (C/B). Well this works out great until I have a positive number in column C and a negative in column B, the percentage will come out to be a negative, but it should be positive. For example:

Actuals | Budget | CM Act vs CM Bud(\$) | CM Act vs CM Bud (%)
22,920 | 24,485 | (1,565) |-6.4%
(2,869) | (3,270) | 401 |-12.3%

That negative 12.3 should actually be a positive. Any help is appreciated. Thank you.

### Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

#### mole999

##### Well-known Member
I think ABS() will fix the value

#### schielrn

##### Well-known Member
Maybe try the following?
Excel Workbook
ABCD
22292024485-1565-6.4%
3-2869-327040112.3%
4-2869-2200-669-30.4%
Sheet4
Cell Formulas
RangeFormula
C2=A2-B2
D2=C2/ABS(B2)

Hope that helps.

#### nymyth

##### Board Regular
I think ABS() will fix the value

Dude, thank you for that...did the trick...how on earth did I forget about ABS()...lol

#### nymyth

##### Board Regular
ended up using this:

=IF(ROUND(J24,1)=0,0%,IF(K24>1,ABS(K24/J24),+K24/J24))

Replies
3
Views
919
Replies
5
Views
469
Replies
11
Views
193
Replies
2
Views
345
Replies
1
Views
289

1,191,688
Messages
5,988,080
Members
440,125
Latest member
vincentchu2369

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back