incubator-ooo-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tony <ableton...@gmail.com>
Subject How to: "if a certain scenario is selected; then..."?
Date Sat, 19 May 2012 08:43:19 GMT
Hello!

How to do a "if EUR is selected in Scenarios A; then multiply the prices
with $1,3135 from the Currencies sheet"?

(would be cool if one single formula could multiply all the prices as
opposed to repeating the same formula across all the
countries<http://en.wikipedia.org/wiki/Don%27t_repeat_yourself>
)

SHEET: SHIPPING PRICES

               Scenarios A (USD, EUR):      Scenarios B (1kg, 1.5kg, 2kg):

Country        Currency                     Price DHL
=======        ========                     =========
Brazil         USD                          N
Russia         USD                          N
India          USD                          N
China          USD                          N

SHEET: CURRENCIES

Currencies
==========
USD   $1.000000
EUR   $1.313500

The actual file can be downloaded:
here<http://user.services.openoffice.org/en/forum/download/file.php?id=14117>

Thanks!

Tony

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message