excel Calculations

  • Thread starter Thread starter K
  • Start date Start date
K

K

I want a cell to be able to have 2 or more differing
values from a select list, with corrsponding values.
eg if cell contains A, then price is b, is cell contains
C, then price is d...... How can i formulate this using
=sumif and or.
 

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

How to find specific field value in sheet. 2
Selective Validation 4
v look value dependant on 2 cells 4
Excel How to get output of the formula instead of True or false 1
Excel formula, sum the value cell and if empty cell left blank 0
excel formula for markup and profit margin 3
Count if criteria extracts from 2 cells both with formulas 2
display list selection in a different cell 2

Back
Top