If Formula question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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",Sheet2!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
 
Back
Top