Microsoft Office Forums - View Single Post - Excel Formula Help??

Thread: Excel Formula Help??

View Single Post

Old

10-03-2016, 03:43 PM

jeffreybrown jeffreybrown is offline

jeffreybrown is offline

jeffreybrown uses Windows Vista

Windows Vista jeffreybrown uses Office 2007

jeffreybrown uses Office 2007

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

jeffreybrown has a spectacular aura about

Default

How about something like...

=IF(D24<=12000,D24*20%,IF(D24>12000,12000*20%+(D24-12000)*25%,""))

and BTW...Next time, please construct a meaningful title

also, seems a cross post without links

http://www.mrexcel.com/forum/excel-q...mula-help.html

Reply With Quote