Looking for help in solving several problems with a spreadsheet I am
working on.
I have spent a lot of time on the Microsoft site trying to find
answers.
1.Would like to hide the 0 (which appears when a date is not known at
a certain time)in a cell when calculating the No.of days i.e A1 date
entered,B1 date exited, C1 =B1-A1.
2.Would also like to hide the word "FALSE" which is returned in a
column of arguments if the argument does not exist.
3.The last one is a bit more complicated. Trading shares in foreign
currencies - I want to calculate the Foreign Currency Rate Movement in
Aust.$ if a share is not bought & sold the same day.
i.e. A1=share price in foreign currency,B1=Entry Exchange Rate, C3 =
Total cost in that currency (A1/B1) although this is also difficult if
the exchange rate is greater than 1 as the formula then needs to be
(A1*B1) don't want to have to go down the column & change when
necessary. Exit is the same as entry with prices for exiting used. The
foreign currency rate movement mentioned above is the difference
between the entry & exit cost.
Thanks in anticipation. Oldie