View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jeffery jeffery is offline
external usenet poster
 
Posts: 9
Default different formulas based on different inputs

I have 3 columns: PriceA, PriceB, PriceC.

For each row, If I input one of the prices, I want the other 2 to be
calculated off of the entered price.
Each entered Price, has a different set of calculated formulas.

How do I set this up so whichever one I enter, the others get calculated?

I think this would be an worksheet_change event, but am not sure.

Thanks for the help,

Jeff Gray