Formula for inserting a $ amount in a Column if certain met

T

TRM

I'm looking for a formula to insert a fixed dollar amount in a column if
certain criteria are met. We have 3 price levels for services defined in a
spreadsheet by a single word e.g. premium ($80), standard ($70), economy
($50). The client would like a new column added to the report which shows the
appropriate price each time the service is used. Rather than have people
enter it manually I would like it to automatically populate the "Fee" column.

Any help is greatly appreciated.

Thanks
 
M

Mike

Try this.
Change A1 to your needs
=IF(A1="Premium",80,IF(A1="Standard",70,IF(A1="Economy",50,"$0.00")))
 
G

Gord Dibben

In Fee column enter this formula

=LOOKUP(A1,{"economy","premium","standard"},{50,80,70})

Where A1 is the cell with the price level.

Note: you could use Data>Validation>List dropdown in A1 to choose from the 3
levels.


Gord Dibben MS Excel MVP
 

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

VLookup + IF 5
adding values if the criteria in two columns are met 1
Multiple IF Statement in Word 5
a function that deletes all rows with no value in a certain column? 2
IF formula with certain conditions to achieve a desired value 2
Add numbers if cell fill is a certain color; How To? 5
Adding a big matrix in Word 2013 5
Return values from one column IF a certain value in another column 9

Top