Maybe this will give you a measure on the possibilities ..
In Sheet1,
You have a DV in A1 which allows the selection of various text, eg:
AddExp1
AddExp2
etc
Then you could have in B1 something like this:
=IF(A1="AddExp1",Sheet2!B1*10,IF(A1="AddExp2",Shee t2!B1*20,""))
B1 will return the amt in Sheet2!B1 multiplied by a factor of 10 or 20,
depending on the DV selection made in A1
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Steve_Dallas" wrote:
I am trying to discover a formula that when any selection is made from a data
validation list, then the amount from another sheet's cell is calculated (as
an added expense)
Hope that makes sense.
Thanks in advance.