formula help with total in same cell

macropod · #15 02-25-2013, 05:43 PM

Quote:

Originally Posted by niton

The hope is that although the OP has not learnt enough to describe this impractical assignment clearly, the intent is to enter data in the F column followed by entering data in the G column. In the Worksheet.Change code the product of F and G will replace the value in G.

Even so, I'd be surprised if the desired result can't be achieved without resorting to Worksheet_Change macros (eg via a series of IF tests or a LOOKUP formula that references a table for the variable values).

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Change formula cell range based on cell value	Scoth	Excel	4	10-25-2012 07:51 AM
Keep cell in formula constant	jprt68	Excel	1	06-26-2012 08:31 AM
need to check whether cell contains formula	etodem	Excel	2	10-23-2010 07:33 PM
Formula in a Cell with condition?	Learner7	Excel	1	07-19-2010 10:10 AM
Protect formula in cell?	markg2	Excel	4	05-24-2010 11:50 AM