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

Help with XLS RTW Pricing Spreadsheet

Community
Wiki Posts
Search

Help with XLS RTW Pricing Spreadsheet

Thread Tools
 
Search this Thread
 
Old Oct 2, 2006, 1:26 pm
  #1  
Original Poster
 
Join Date: May 2000
Location: Miami 7-Million Miler EXP
Posts: 829
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, 2006, 1: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  


Contact Us - Manage Preferences - Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service -

This site is owned, operated, and maintained by MH Sub I, LLC dba Internet Brands. Copyright © 2024 MH Sub I, LLC dba Internet Brands. All rights reserved. Designated trademarks are the property of their respective owners.