# 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

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

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

Replies
4
Views
159
Replies
4
Views
120
Replies
1
Views
93
Replies
12
Views
244
Replies
4
Views
219

1,129,683
Messages
5,637,779
Members
416,982
Latest member
lisam77

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