# Solved Excel: Formulas not calculating

Discussion in 'Business Applications' started by Koroshiya, May 28, 2019.

Not open for further replies.

Joined:
Oct 25, 2006
Messages:
95
First Name:
Rob
So, I'm sure I've got some sort of weird syntax issue going on, or something, but I banging my head against it trying to figure out what exactly I'm doing wrong.

Here are the formulas that are not calculating:

Code:
`=IF(ISBLANK(B2),"",E2=B2+C2-D2)`
If B2=5, C2=6 and D2=2, E2 returns 0. No matter what value is entered into any of those fields, the return is 0.

Code:
`=IF(B2="","",F2=B2\E2)`
Returns 0% no matter what values are entered. Tried a different conditional, but the issue persists.

The goal is to hide calculated fields until the manually inputted fields are populated, then calculate.

Joined:
Nov 28, 2005
Messages:
62,061
First Name:
Chuck
CORECTED:

The second equal sign in your first formula and the third equal sign in your second formula are telling Excel to compare the value to the left of the equal sign to the value to the right of the sign. It returns a 1 (True) if they are equal, and 0 (False) if they are not equal. As far as I know, you cannot have an Excel formula change the value of a cell other than the cell that contains the formula.

Last edited: May 28, 2019
Koroshiya likes this.

Joined:
Nov 28, 2005
Messages:
62,061
First Name:
Chuck
If your first formula is in cell E2, change the formula to
Code:
`=IF(ISBLANK(B2),"",B2+C2-D2)`
If your second formula is in cell F2, change the formula to
Code:
`=IF(B2="","",B2\E2)`

Koroshiya likes this.

Joined:
Oct 25, 2006
Messages:
95
First Name:
Rob
Awesome, thank you! I think I understand how I got to using "Cell=Formula" and the information you gave me helped clear up the issue that was causing that. When I plugged your formula in, which I had been using originally, it returned "#Name?" After playing around a bit, I realized I messed up my syntax. Something as silly as the wrong slash for division. When I used "Cell=Formula" it returned a 0, so I assumed it was working until it was time to actually calculate the field.

Joined:
Nov 28, 2005
Messages:
62,061
First Name:
Chuck
You're welcome. We both missed the reverse slash the first time around.

Koroshiya likes this.

As Seen On