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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 02:53 AM.