Microsoft Excel Conditional Formatting

Closed
bunnyboy123 Posts 2 Registration date Wednesday August 12, 2015 Status Member Last seen August 13, 2015 - Aug 12, 2015 at 02:33 PM
Mazzaropi Posts 1965 Registration date Monday August 16, 2010 Status Contributor Last seen September 18, 2022 - Aug 13, 2015 at 12:06 PM
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

Mazzaropi Posts 1965 Registration date Monday August 16, 2010 Status Contributor Last seen September 18, 2022 146
Aug 13, 2015 at 08:06 AM
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
bunnyboy123 Posts 2 Registration date Wednesday August 12, 2015 Status Member Last seen August 13, 2015
Aug 13, 2015 at 11:43 AM
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
Mazzaropi Posts 1965 Registration date Monday August 16, 2010 Status Contributor Last seen September 18, 2022 146
Aug 13, 2015 at 12:06 PM
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