| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keeping Exchange Rate With Status
hi,
my xchange rate is in A1 which is chang on daily basis, so i want if status is in stock then want let change exr on daily basis, if status is changed to sold then want keep previous rate. A1 = Exchange rate (change on daily basis) B4 = Status (change when product sold) =IF($B4="Stock",$A$1,"") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FORMULA: calculating an exchange rate | Excel Discussion (Misc queries) | |||
| How to create a Exchange Currency Rate into Excel | Excel Worksheet Functions | |||
| euro-sterling exchange rate | Excel Discussion (Misc queries) | |||
| vlookup for exchange rate | Excel Worksheet Functions | |||
| how to calculate exchange rate? | Excel Discussion (Misc queries) | |||
Threaded Mode
