[Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register]

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
jrkrideau
Super User

Joined: 08 Aug 2005
Posts: 6732

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
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2
David
Super User

Joined: 24 Oct 2003
Posts: 5668

 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.
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First
 All times are GMT - 8 Hours Page 1 of 1

 Jump to: Select a forum OpenOffice.org Forums----------------Setup and TroubleshootingOpenOffice.org WriterOpenOffice.org CalcOpenOffice.org ImpressOpenOffice.org DrawOpenOffice.org MathOpenOffice.org BaseOpenOffice.org Macros and APIOpenOffice.org Code Snippets Community Forums----------------General DiscussionSite Feedback
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum