Calculating Pricing based upon Mhz

L

lkw441

I have a spreadsheet with (773) Cells With a value 'i.e. 300Mhz'.
would like for a cell to be able to calculate a value that I put in.
Such as:

If M2:M772 = 300 Mhz then the value = $18
If M2:m772= 333 Mhz then the value = $20

and so on. Can I do one formula with multiple values to compare to an
based upon this cell generate another value? I can do a cut and pas
but it's a pain. Thanks for your help.

Larr
 

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

Sum calculation based on condition 6
Linking a selection in a drop down list to a calc in another cell 6
Running total based upon current date 5
How do I calculate a specific formula for price increases? 3
How to color cells based upon a value in another cell 1
Change formulas in a column based on a selection. 3
Formula to auto calculate based on other variables 8
Limitations on Sumif Calculation 3

Top