excell formula quandry

[ottasight]

how can i make these work
in a1 cell, =if(b1<10,"",a10=a10+1)
in a1 cell, =if(b1<10,"",a10=a10+b1).........thanks

 

[Weaver]

Are you trying to have a value and a function in the same cell?

 

[ottasight]

im placing a function/formula in one cell that affects a total/value in a different cell

 

[Matty]

What differentiates the two tests you mention? I mean, in what scenario is it A10+1 and in what scenario is it A10+B1?

A short example - as well as the desired result - will help us to understand.

Matty

 

[shg]

Your formula suggests that A10 is to be changed by the formula in A1 -- that won't happen. A formula in Excel can't do anything except return a value to the cell in which it appears.

 

[ottasight]

thanks SHG.... guess i'll need to find another solution