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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Overwriting a cell with a formula without deleting the formula 1
Copy corresponding cell in Column B if cell in A contains certain text? 1
using the =page! feature to transpose a row to column 0
@if question 4
Multiple Columns for SUMIF formula?!?! 2
Referencing formula using Indirect 4
Help required on Tabulating monthly expenses for the Current Month,Previous Month and Month previous 12
How do I create a formula in excel to multiply two items from two 2

Back
Top