|
|
#1
07-31-2016, 03:22 PM
|
|||
|
|||
Multiple IF
Hello there once again!
does any fine individual out there how to help me with the following, I have the following in a cell, =IFS(K81<3000,K81*0.1,K81<50000,K81*0.08,K81>=5000 0,K81*0.06) I would like the number in the cell to display 10%, 8% or 6% depending on the value of the sum Is this possible, I have been at this for some time and the attachments shows you all how well I have done Thanks Jonathan 
|
|
#2
07-31-2016, 11:23 PM
|
||||
|
||||
|
Hi
please do not post a new question in an existing thread, but create a new one. If relevant you can add a link to the other thread. In this case however this does not seem to be the case. I created a new thread for you Also please post a small sample sheet instead of a large, but useless image. Thank you
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
#3
08-01-2016, 06:11 AM
|
|||
|
|||
|
Is the third test 5000 (as in the first equation) or 50000 (as in the second). Anyhoo, this should work. Modify as needed.
Code:
=IF(K81<3000,K81*10%,IF(K81>=5000, K81*6%,K81*8%))
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 I need to add multiple values based on multiple criteria in a cell not sure what to do
|
AUHAMM | Excel | 3 | 10-27-2014 09:11 PM |
| Create multiple copies of same email in multiple folders | gaker10 | Outlook | 0 | 10-06-2014 07:44 AM |
|
Copy Multiple Rows to new workbook when multiple criteria is met.
|
flds | Excel Programming | 5 | 09-30-2014 09:58 AM |
|
Multiple VLOOKUP's checking multiple Cells
|
OTPM | Excel | 11 | 05-23-2011 11:18 AM |
| Multiple task lists and multiple calendars | kballing | Outlook | 0 | 01-18-2011 10:23 AM |
Windows 10 
Office 2016
Linear Mode
