# Excel - Two Formulas, One Cell

Discussion in 'Business Applications' started by amigoes5, Jun 17, 2015.

Not open for further replies.

Joined:
Jun 17, 2015
Messages:
1
Hi,

In Excel can you have two formulas for one cell? On the example below, I need to have it so it goes +100% if they are over their goal but -100% if they fall below. I have the conditioning rule for the negative to go red.

Varietal Ship Goal Shipped +/- Percent of Goal
Chard 385 602 156%
T Chard 32 9 -72%

Also, for some reason the other person who works on these files along with me, cannot highlight the row if there is a conditioning rule anywhere? Any thoughts on this as well would be quite helpful. Thanks in advance!

Joined:
Mar 27, 2008
Messages:
6,553
First Name:
Hans
Hi, welcome to the forum.
Two formulas is a no no, but the formula can have nested IF and OR statements, your example is not quite clear (to me)
About highlighting, if conditional formatting is actie in that cell you can change and hightlight what you want, conditional formatting overrules this.

Joined:
Aug 31, 2002
Messages:
189
First Name:
Jenn
amigos, if I understand what you are looking for correctly, the following might help you get your results

Code:
```COLUMN B       COLUMN C      COLUMN D
385               602            =+IF(C2>B2, ROUND(C2/B2*100,0), ROUND(C2/B2*100-100,0)) --> results 156
32                 9             =+IF(C3>B3, ROUND(C3/B3*100,0), ROUND(C3/B3*100-100,0)) --> results -72```

As Seen On