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

Try something like =IF(ISNUMBER(B20),B20*E20*G20,"No x in B20")

Dave
--
Brevity is the soul of wit.


"Jesse" wrote:


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

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

X in your formula is text, not a number. You can't multiply text.
--
Brevity is the soul of wit.


"Conan Kelly" 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

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

Jesse james....will u populate this formula on a row or column...or this is
for one cell formula only ??

"Jesse" wrote:


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

lets go the way assuming a one cell formula...with a touch of dave's formula
I20=IF(ISNUMBER(B20),B20*E20*G20,IF(B20="X",E20*G2 0,"No x in B20"))
if you type other text or even a space in B20 the result is "No x in B20"...
i still wonder why you need the text "B20" like rml had noted.....

"rml" wrote:

Jesse james....will u populate this formula on a row or column...or this is
for one cell formula only ??

"Jesse" wrote:


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

THANKS to "everyone"! Everyone gave a good example of the formula and
I'll play with them to obtain the one I like best. I will be using
this in several rows, but it will always be the same formula, just
different numbers in each column. The "No X in B20" thing is just to
tell whomever is using the sheet, that they need some input in B20 in
order to get their answer. I will change the X to #. Have to make it
simple for simple minds.

Again, THANKS for your help, you guys and gals are great.

Have a great week............

Jess n Milton, FL

On Mon, 13 Nov 2006 13:11:28 -0600, Jesse
wrote:


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