Calculating bonus in an embedded IF function

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Calculating bonus in an embedded IF function

07-21-2018, 02:03 PM

jeffreybrown jeffreybrown is offline

Windows Vista Calculating bonus in an embedded IF function

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

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}))) ,"")

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Create Personnel Tracker that can output Bonus to a different worksheet	FredRich	Excel	2	10-10-2017 01:07 AM
Restrict Editing function disable insert textbox function	IanM_01	Word	5	11-21-2015 02:29 AM
Countif function not calculating correctly	MoranGail	Excel	1	07-09-2014 05:50 AM
#REF! Error in calling VBA function disappears when function is copied	lcaretto	Excel Programming	2	05-26-2014 07:19 PM
Creating a graph for Future Value function (FV function)	bmoody	Excel	2	11-06-2013 10:52 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:54 PM.