I would like a statement that does the same as the IF function, but i need more than two outcomes...
To explain... or try to explain
I have a column that states whether a customer is in the A,B, or C bracket on a quote sheet, and they receive a different discount depending on which bracket they fall in...
What it will be for example, is A customers receive a 30% discount off list price, B get 15% and C get no discount (so pay list price)...
Probably is a simple fix but...
Maybe INDEX& MATCH, could works, but it's better to upload a small sample workbook.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Test Book 1.xlsx
Attached is the Test Book...
What i need (keeping all the rest of the formatting the same) is the following...
Sheet1...
I17 = (H17xC17)x 0.7 IF (F13=``A``)
I17 = (H17xC17)x 0.85 IF (F13=``B``)
I17 = (H17xC17)x 1.0 IF (F13=``C``)
Please note i would like to keep the formatting in the I column of =IF(F15="","",(H19*C19))
Attachment 187505
Attached is the Test Book...
What i need (keeping all the rest of the formatting the same) is the following...
Sheet1...
I17 = (H17xC17)x 0.7 IF (F13=``A``)
I17 = (H17xC17)x 0.85 IF (F13=``B``)
I17 = (H17xC17)x 1.0 IF (F13=``C``)
Please note i would like to keep the formatting in the I column of =IF(F15="","",(H19*C19))
Hi
One way could be this.
Create a table with Customer types and discounts. Example I2:J4, IN Customer Sheet.
Then in I16 and copy down of Quote Sheet, use this formula.
Is this, works for you?
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks