Microsoft Office Forums - View Single Post - [Solved] Calculating bonus in an embedded IF function

Thread: [Solved] Calculating bonus in an embedded IF function

View Single Post

Old

07-21-2018, 02:03 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

Is this a start?

=IF(N(C2),IF(AND(A2="CEO",B2="Yes"),"",IF(AND(A2=" MD",B2="Yes",C2>8),"",LOOKUP(C2,{1,1;7,1.5;9,2}))) ,"")

Reply With Quote