FlyerTalk Forums - View Single Post - Excel question
Thread: Excel question
View Single Post
Old Dec 6, 2006 | 11:58 pm
  #6  
PCTraveler
 
Join Date: Jul 2006
Location: LAX
Programs: UA 1P MM, SPG Lifetime Gold
Posts: 654
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.
PCTraveler is offline  
Reply