# Getting #VALUE error when using a cell that contains another formula

#### mpatino

##### Board Regular
Hi Experts,

I am trying to do some calculation in cell A4 taking in consideration the result of another calculation done in B4, but I am getting error #VALUE, so I was wondering if someone could help me understand why I am getting this error. I supposed I am getting the error because I am trying to calculate against a cell with a formula and not against an actual value, if this is so, do anyone knows how can I have my formula in A4 take the formula in B4 as a value and not as text? This is what I am doing:

 A B C D 1 WW50 WW51 WW52 WW53 2 5000 3500 3 10500 3500 4 IF(A5=1,B4+ROUNDUP(A2/\$A\$7,0)*\$A\$7) (I get the error here = #VALUE) IF(AND(B5=1,SUM(A8:B8)>A6),"",IF(B5=1,C4+ROUNDUP(B2/\$A\$6,0)*\$A\$6)) 5 1 1 1 1 6 SUM(A1:D1) 7 3500 8 IF(A5=1,B4+ROUNDUP(A2/\$A\$7,0)*\$A\$7) IF(B5=1,C4+ROUNDUP(B2/\$A\$6,0)*\$A\$6))

<tbody>
</tbody>

Appreciate the assistance with this issue.

<colgroup><col><col span="4"></colgroup><tbody>
</tbody>

### Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

#### Kenneth Hobson

##### Well-known Member
Where is the false part after the True condition is set? Setting it to NA():

=IF(A5=1,B4+ROUNDUP(A2/\$A\$7,0)*\$A\$7, NA())

Of course when dividing by a number, it can not be empty or 0. If so, it will error.

#### Anand Sharma

##### Board Regular
Your formulas having many errors here

You cannot sum A1:D1 as cells have text values

Cell B4 and A8 have circular reference error

Post what result you want here so that i can help

#### mpatino

##### Board Regular
Thank you guys for your quick replies, I fixed the problem just by changing the the expresion IF(B5=1,SUM(A8:B8)>A6),"") to IF(B5=1,SUM(A8:B8)>A6),0), it looks like the formula didn't like an empty field.

#### mpatino

##### Board Regular
I meant to say A2 instead of A1, thankyou

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,164,571
Messages
5,838,160
Members
430,532
Latest member
Clod

### 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