Using Value of Formula as an argument

[A Taylor]

Hi, I am trying to use the value of a formula as an argument in another formula and I get the Value Error, which I have corrected, but is there anyway to only use the Result of the formula in the argument as it is the formula that is causing the error

Column G formula is =IFERROR(IF(OR(B4>0,C4>0),SUM(C4:F4),""),"")

Column C has the formula = IF(B3>0,B3/2.88,"") which causes the error in column G

I want the formula in column G to only use the result or value of column C in the argument

Hope this makes sense
Thanks in anticipation

 

[RoryA]

Not sure what you mean - the dependent formula only looks at the value returned by the precedent formula.

 

[A Taylor]

Solved the problem - I used the COUNT function as the argument - which returns the number in a range with values.

I love Excel

 

[A Taylor]

Hi Rorya, thanks for your reply

The problem I had was that the formula in column C returned "" most of the time. I suppose I could have used 0 as the return , but that makes the spreadsheet look messy