Jun 10 2018
10:21 AM
- last edited on
Jul 31 2018
08:25 AM
by
TechCommunityAP
Jun 10 2018
10:21 AM
- last edited on
Jul 31 2018
08:25 AM
by
TechCommunityAP
It's been a little while since I've used Excel and I am having trouble writing out this formula. The formula has to follow these 3 criteria:
Calculate each employee’s bonus amount on Tab 1 and enter the bonus amount under column named Bonus Received by following instruction below.
It is the 2nd criteria I am having trouble entering into my nested IF function.
Any help would be greatly appreciated!
Jun 10 2018 11:52 AM
Hi Marissa,
It could be
=IF(A1>2080,250,IF(A1>200,A1/2080*250,0))