View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default Seperate formula depending on cell used

I can come back to the problem on Monday, if you don't get an answer from
somebody else until then.
Stefi


€žduckydon€ť ezt Ă*rta:

That has confused me even more. Where would I find out how to create the sub
macro

"Stefi" wrote:

No, it can be achieved only via a Change_event sub macro.

Regards,
Stefi

€žduckydon€ť ezt Ă*rta:

Hi
Total beginner but hoping someone can help.
Can a formula be created in one cell (e2 say) so if a value is entered in c2
it would add to the value in e2, however, if a value is entered in d2 it
would subtract from the value in e2?
Thank you