I would like a little help with a formula, please
Or maybe =IF(B20="x","no number in B20",E20*G20*B20)
Not sure what you want to enter in B20............"x" or a number?
Gord Dibben MS Excel MVP
On Mon, 13 Nov 2006 12:24:00 -0700, "Conan Kelly" <CTBarbarin at msn dot com
wrote:
Jesse,
Try this:
=IF(B20="x",E20*G20*B20,"No X in B 20")
I think that will accomplish what you described.
I hope this helps,
Conan Kelly
"Jesse" wrote in message ...
I am using the following formula in cell I20, =IF(B20="x",E20*G20,"No
X in B 20") which works fine. I want to change it where in cell B20 I
can input any number, then the formual will do the E20*G20 and also
multiply by the number in B20. I would think that is pretty simple
for you Excel guru's but not for me :-).
Thanks!
Jess
|