FlyerTalk Forums - View Single Post - Excel question
Thread: Excel question
View Single Post
Old Dec 7, 2006 | 4:19 am
  #7  
bensyd
FlyerTalk Evangelist
All eyes on you!
20 Years on Site
 
Join Date: Feb 2005
Location: RSE
Programs: AA Exp|VA Platinum
Posts: 15,913
Originally Posted by PCTraveler
Try having 2 sets of the 3 columns (Sale price, Markup, and Cost). One set is your data entry set and the other would have IF formulas. You should then be able to enter any 2 of the 3 and have the 3rd calculated, with the other 2 carried over.

Thats done the trick thanks. Is there anyway now I can get the numbers in the data entry set to update to the data in the IF formulas as in if i enter say m/up and cost and it fills the fields in the "IF formulas columns" can I get it to reverse back and fill the blank sale price cell in the data entry set or is this circular???

thanks for all you help everyone
bensyd is offline  
Reply