Go Back  FlyerTalk Forums > Miles&Points > Global Airline Alliances > oneworld
Reload this Page >

Help with XLS RTW Pricing Spreadsheet

Help with XLS RTW Pricing Spreadsheet

Old Oct 2, 06, 2:26 pm
  #1  
Original Poster
 
Join Date: May 2000
Location: Miami 7-Million Miler EXP
Posts: 825
Help with XLS RTW Pricing Spreadsheet

Latest pricing spreadsheets
WearyBizTrvlr - http://qsi.cc/users/wbt/RTW%20Fares.xls


When I try to load this spreadsheet with Quattro Pro, I get an error message:

: Cannot load a formula, only its value. Modified cells will be displayed in red. continue?

The red cell for OW Fares is E2. (To the right of "Currency" line).

What is the formula for E2? Thanks.
MiamiPrep is offline  
Old Oct 2, 06, 2:53 pm
  #2  
 
Join Date: Jun 2004
Location: Madrid, Spain & Santiago, Chile
Programs: AA EXP
Posts: 3,181
Originally Posted by MiamiPrep
...What is the formula for E2?
="exchange rates updated " & TEXT( fxDate;"dd-mmm-yyyy")

The date format above is taken from my system default, yours will probably differ.
Viajero is offline  

Thread Tools
Search this Thread