| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Seperate formula depending on cell used
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Seperate formula depending on cell used
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Seperate formula depending on cell used
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Seperate formula depending on cell used
<Where would I find out how to create the sub macro
Don't. Change your setup, so that another cell is updated, not the cell with the formula in it. But if you really do need that, read this: http://www.mcgimpsey.com/excel/accumulator.html -- Kind regards, Niek Otten Microsoft MVP - Excel "duckydon" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| To copy the formula in one cell to another in a seperate sheet | Excel Discussion (Misc queries) | |||
| Fill a seperate cell with info depending on the input in another c | Excel Discussion (Misc queries) | |||
| Copy content of cell to another depending on value of third cell(between worksheets) | Excel Worksheet Functions | |||
| How can i change cell colour depending on month of date in cell? | Excel Discussion (Misc queries) | |||
| Formula to Seperate data in 1 cell | Excel Worksheet Functions | |||
Linear Mode
