View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jesse Jesse is offline
external usenet poster
 
Posts: 2
Default I would like a little help with a formula, please


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