ExcelBanter - Help...if formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Help...if formula (https://www.excelbanter.com/excel-discussion-misc-queries/45980-help-if-formula.html)

stacy

Help...if formula

I need a formula that does the following...if a grade is 60 or greater, add 5
points to it. If the grade is between 50 and 60, add 10 points to it. If the
grade is below 50, make it 60.

Myrna Larson

=IF(A1<50,60,IF(A1<60,A1+10,A1+5))

or

=A1+IF(A1<50,60-A1,IF(A1<60,10,5))

On Sun, 18 Sep 2005 14:50:01 -0700, "stacy"
wrote:

I need a formula that does the following...if a grade is 60 or greater, add 5
points to it. If the grade is between 50 and 60, add 10 points to it. If the
grade is below 50, make it 60.

Max

You've also got some responses
in your multi-post over in .worksheet.functions ..
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

All times are GMT +1. The time now is 07:11 AM.