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

[mpatino]

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>

 

[Kenneth Hobson]

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]

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]

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]

I meant to say A2 instead of A1, thankyou