lordbyron1814
New Member
- Joined
- Mar 25, 2002
- Messages
- 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(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?
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?