View Single Post
 
Old 10-26-2014, 08:30 PM
AUHAMM AUHAMM is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Oct 2014
Posts: 2
AUHAMM is on a distinguished road
Default I need to add multiple values based on multiple criteria in a cell not sure what to do

Ok so I basically need to make two separate if statements for a column of data and i have no idea what i am doing. The spreadsheet is about how much students can earn on a scholarship based on their GPA and experiential activities. for data column B i have an initial offer of $29,705 for every student, column C displays the GPA and column D the Experiential activities(numerical value). I need a function for column E that adds 2,000 to the initial offer if the GPA is greater than 3.5, +1,000 if greater than 3.0 and +500 if greater than 2.5 and also based on the experiential activities adding 3,500 if activities greater than 4.5, +3,000 if > 4.0, +2,500 if > 3.0, +2,000 if >2.0 and +1,000 if > 1.0.

so for example;

Xavier got a GPA of 3.6 and a 2.1 on experiential activities so based on the criteria he should have 2,000 added to the initial offer for his GPA and an additional 2,000 added for his experiential activities resulting in his highest offer being 33,705.

initial offer:29,705 +GPA bonus:2,000 + Experiential activities bonus:2,000= 33,705
Reply With Quote