I need to add multiple values based on multiple criteria in a cell not sure what to do

macropod · #1 10-26-2014, 11:33 PM

Assuming the values are on row 2, the following formula will calculate the bonuses:
=500*(C2>2.5)+500*(C2>3)+1000*(C2>3.5)+1000*(D2>1) +1000*(D2>2)+500*(D2>3)+500*(D2>4.5)
To have the full value calculated instead of just the bonus, add +29705 to the formula:

=500*(C2>2.5)+500*(C2>3)+1000*(C2>3.5)+1000*(D2>1) +1000*(D2>2)+500*(D2>3)+500*(D2>4.5)+29705
Simply copy down as far as needed.

AUHAMM · #2 10-27-2014, 08:37 PM

Thank you this worked perfectly! I am a little confused on how though. could you explain how I got the numbers I needed by using *500 and *1000? I am not sure what is going on here in general. Sorry for my lack of experience

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copy Multiple Rows to new workbook when multiple criteria is met.	flds	Excel Programming	5	09-30-2014 09:58 AM
Insert values from multiple rows based on value in one column	pachmarhi	Excel	3	07-18-2014 09:57 PM
Change values in cells based on criteria	SaneMan	Excel Programming	2	02-02-2012 07:58 AM
How to count multiple values in a single cell, except zero?	iuliandonici	Excel	1	04-13-2011 09:45 PM
Sum & difference between multiple values in a single cell	iuliandonici	Excel	4	04-13-2011 09:27 PM