Formula in excel

Microsoft Excel 2003 (full product)
February 2, 2010 at 19:39:42
Specs: Windows XP
Hi, I am sakona, I want to know about some formula bellow,

I have score like these: 10,12,20,8,A,F,19 I want to add 3point on that, after add, if it bigger than 20 please equal 20, if less than or equal 20 keep it the same score but if score equal "A" or "F" please keep it.


See More: Formula in excel

Report •

February 3, 2010 at 05:48:57
I'm going to move this to the Office forum, but I doubt they want to do your homework, either.

Report •

February 3, 2010 at 06:08:15
Since our friend Razor2.3 thinks this might be homework, I'll give you the concept and ask you to try it on you own. If you can't get it to work, come on back with what you tried and we'll offer some more suggestions...

You'll need to use a Nested IF function, along with an OR function.

For example...


In this case, the value_if_true would be A1 and the value_if_false would be another IF function testing your next criteria, e.g.

IF(A1+3>20,value_if_true, value_if_false)

Review the Excel Help files on the IF function where they give examples of Nested IF's.

Report •

Related Solutions

Ask Question