Keeping Exchange Rate With Status
it's manually input...
"Atishoo" wrote:
hi
is the exchange rate in a1 updated manually by a user or is it a formula
that calculates exchange rate dependant on something else?
"Tufail" wrote:
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,"")
|