Related:

- Excel, formula adding point to answers.
- Excel grade formula - Guide
- Number to words in excel formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Little alchemy answers - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers

## 2 responses

venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811

Nov 23, 2009 at 05:59 AM

Nov 23, 2009 at 05:59 AM

why not this

=IF(A1="blue",1,IF(A1="green",2,IF(A1="yellow",3,"")))

=IF(A1="blue",1,IF(A1="green",2,IF(A1="yellow",3,"")))

but if i type in "green" for the cell in A1, it will turn 2 instead of 1. Because although "green" is a answer, but only counted as only 1 point.

Condition:

if type in "green and blue", 2 points

if type in "yellow and blue", 2 points

if type in "yellow" 1 point

if type in "green" 1 point

if type in "hello" 0 point

if type in "hello, i am yellow and green people" 2 points

Condition:

if type in "green and blue", 2 points

if type in "yellow and blue", 2 points

if type in "yellow" 1 point

if type in "green" 1 point

if type in "hello" 0 point

if type in "hello, i am yellow and green people" 2 points