![]() |
|
#1
|
|||
|
|||
![]()
=SUMPRODUCT(1*(A1>({0,5000,10000})),(A1-({0,5000,10000})),({1.6,-0.4,-0.2}))
where A1 holds the amount entered. |
#2
|
|||
|
|||
![]() Quote:
Well it worked - thank you very much But, I don't understand it. |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Marking specific cells depending on start and end time entered | ellebb85 | Excel Programming | 0 | 01-17-2016 02:50 AM |
different rates on sunday | pascalbidouille | Project | 1 | 07-01-2015 01:58 PM |
![]() |
Cellendhyll | Word Tables | 3 | 07-10-2014 05:49 AM |
![]() |
decker | Project | 6 | 02-07-2014 03:23 PM |
![]() |
Natasha | Excel | 1 | 09-25-2011 12:59 PM |