Using IF statement to perform SUM or insert pre-defined stat

lordbyron1814 · Mar 26th, 2002, 01:20 PM

If I type the letter "E" into J1 I want Excel to perform the auto sum feature. if there isn't an "E" in that box I want a number "0"

using this formula I was able to achieve half of that...

=IF(J1="E","=SUM(K1*C8)",0)

the "O" appears when it isn't an "E"

however if it IS an "E" I get the typed out "=sum (k1*c8)".

How do I force excel to do the math?

Juan Pablo González · Mar 26th, 2002, 01:24 PM

Change that to

=IF(J1="E",K1*C8,0)

There's no need for the SUM function there, since you're only giving it one parameter.

lordbyron1814 · Mar 26th, 2002, 01:31 PM

Thank you- I removed the =sum from the formula. however the math is still not being done. something else must be wrong...

lordbyron1814 · Mar 26th, 2002, 01:33 PM

I forgot to remove the parenthesis! thank you- It works! You've saved me 3 hours of re-occuring work!

Tom Schreiner · Mar 26th, 2002, 01:33 PM

Hi
Doublecheck everything.

The formula given by Juan Pablo G. is correct.

Tom

Aladin Akyurek · Mar 26th, 2002, 03:29 PM

Quote:

On 2002-03-26 12:33, lordbyron1814 wrote:
I forgot to remove the parenthesis! thank you- It works! You've saved me 3 hours of re-occuring work!

I think Juan would want to edit what he suggested

=IF(J1="E",K1*C8,0)

to the shorter:

=(J1="E")*(K1*C8)

Mar 26th, 2002, 01:24 PM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	Change that to =IF(J1="E",K1*C8,0) There's no need for the SUM function there, since you're only giving it one parameter. __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 26th, 2002, 01:20 PM	#1
lordbyron1814 New Member Join Date: Mar 2002 Posts: 3	If I type the letter "E" into J1 I want Excel to perform the auto sum feature. if there isn't an "E" in that box I want a number "0" using this formula I was able to achieve half of that... =IF(J1="E","=SUM(K1C8)",0) the "O" appears when it isn't an "E" however if it IS an "E" I get the typed out "=sum (k1c8)". How do I force excel to do the math?

Mar 26th, 2002, 01:31 PM	#3
lordbyron1814 New Member Join Date: Mar 2002 Posts: 3	Thank you- I removed the =sum from the formula. however the math is still not being done. something else must be wrong...

Mar 26th, 2002, 01:33 PM	#4
lordbyron1814 New Member Join Date: Mar 2002 Posts: 3	I forgot to remove the parenthesis! thank you- It works! You've saved me 3 hours of re-occuring work!

Mar 26th, 2002, 01:33 PM	#5
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Hi Doublecheck everything. The formula given by Juan Pablo G. is correct. Tom