| View previous topic :: View next topic |
| Author |
Message |
njabeen
General User
Joined: 04 Jul 2008
Posts: 8
|
 Posted: Thu Jul 24, 2008 10:40 pm Post subject: Need default values...but sometimes don't |
 |
|
So, let me explain the situation followed by the problem/question. Basically I have cell where currency is selected and the cell below it has a formula to enter default exchange rates into USD. SO:
E1 = Currency
E2 = Exchange rate (to USD)
Formula in E2:
=IF(E1="USD";"-";IF(E1="HKD";7.75;IF(E1="RMB";6.75)))
SO:
USD = -
HKD = 7.75
RMB = 6.75
These are the defaullt exchange rates used when none are specified. So when currency is selected the respective exchange rate is automatically entered in E2.
However, sometimes a more up to date exhange rate is specified so I want to be able to enter the exchange rate into E2, without losing the formula. is that even possible? If not any suggestions on how else I could do this?
Thanks!
NJ |
|
| Back to top |
|
 |
jrkrideau
Super User
Joined: 08 Aug 2005
Posts: 6733
Location: Kingston ON Canada
|
| Posted: Fri Jul 25, 2008 4:51 am Post subject: Re: Need default values...but sometimes don't |
|
|
| njabeen wrote: | So, let me explain the situation followed by the problem/question. Basically I have cell where currency is selected and the cell below it has a formula to enter default exchange rates into USD. SO:
E1 = Currency
E2 = Exchange rate (to USD)
Formula in E2:
=IF(E1="USD";"-";IF(E1="HKD";7.75;IF(E1="RMB";6.75)))
SO:
USD = -
HKD = 7.75
RMB = 6.75
These are the defaullt exchange rates used when none are specified. So when currency is selected the respective exchange rate is automatically entered in E2.
However, sometimes a more up to date exhange rate is specified so I want to be able to enter the exchange rate into E2, without losing the formula. is that even possible? If not any suggestions on how else I could do this?
Thanks!
NJ |
Are you saying that E2 is an equation not a number? If so, a crude approach might be to use an IF statement here as well and have the formula pull the number from XX automatically and pull from a input cell if you manually set a new exchange value in the input cell.
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2 |
|
| Back to top |
|
|
David
Super User
Joined: 24 Oct 2003
Posts: 5668
Location: Canada
|
| Posted: Fri Jul 25, 2008 9:42 am Post subject: |
|
|
Put exchange rates into certain cells and reference those cells rather than use the typed in values. When you change the values in those cells, the formula will automatically adjust.
David. |
|
| Back to top |
|
|
|
