Microsoft Excel Conditional Formatting

Closed
Report
Posts
2
Registration date
Wednesday August 12, 2015
Status
Member
Last seen
August 13, 2015
-
Posts
1950
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
January 9, 2022
-
Hi,

I'm trying to make a cell display a number based whether or not another cell contains the words, "Sentinel", "Ramsden", "Goulding", or "Riverdale".

Thanks,
Bunnyboy

3 replies

Posts
1950
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
January 9, 2022
148
Bunnyboy, Good morning.

The conditional format works only aesthetic aspects.

As you need a logical answer, the correct is you use the IF FUNCTION.

Example:
A1 has the formula:
= IF(B1 = "Sentinel", 2, IF (B1 = "Ramsden", 5 .... etc.

Please, explaine a little better your necessity.
I believe that many people will arrive to help you.
0
Posts
2
Registration date
Wednesday August 12, 2015
Status
Member
Last seen
August 13, 2015

Thanks that helps a lot. Now the only problem I have is that if it doesn't contain one of those names, I'd like to make it display "0". And also add half of a an adjacent box depending on whether or not a box is TRUE or FALSE
0
Posts
1950
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
January 9, 2022
148
Please, show us your formula to easier our help to you.

I don't understand:
"...And also add half of a an adjacent box depending on whether or not a box is TRUE or FALSE..."

Does it means that you have a number on adjacent box and you want to add half of this number?

Save your file at a free site, www.speedyshare.com e put a link to download here.

Tell us what data you have and what you expect to receive as result.
Put the result manually to show us your necessity.
0