|
|
#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 
|
| Thread Tools | |
| Display Modes | |
|
|
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
Threaded Mode