Excel help needed

[kdr1974]

Hi

Newbie here so I hope I have the right board... Two questions...

Trying to write a formula which captures risk and liklihood.

What I am after is a cell to display a text value depending on whether the previous two cells contain Low, Medium or High text values.

So H/H would return one value, L/M would return another one, etc. Is there an easy way to do this?

Edit - Sorry, my other question is I have a huge list of data and I have to make some lines bold manually but then need to remove any bold text from the sheet - is there an easy way to strip out bold data? Usually I have to delete every line manually...


Thanks
Kyle

 

[SkipVought]

hi,

"Is there an easy way to do this?"

Yes, use an IF function or a list lookup.

"I have to make some lines bold manually"

What is the logic for this decision? You may be able to set the bold with Format > Conditional Formatting and AutoFilter using similar logic, after which you can DELETE in one operation.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[kdr1974]

Many thanks for help.

I don't understand how to use the IF command with AND which I presume I need to since I am asking it to look at two values before producing a third, which I am also unsure of.

The bold is for a bill I am separating out so I delete the bold lines to leave the amount payable, line by line, not sure how conditonal formatting would work in that case... I didn't think AutoFilter worked on formats?

Kyle

 

[SkipVought]

I was referring to LOGIC not formats. "What is the logic for this decision?"

Apparently you are making row fonts bold based on some order form and there is no logic to your decision to make a row font bold..

So, instead, place a value in a column for each row you want to delete or filter, rather than using a format. SIMPLE!

Regarding the IF function, you can use the AND function or not...
[tt]
=if(first_expression,if(second_expression,result_both_true,result_both_not_true),result_both_not_true)
or
=if(and(first_expression,second_expression),result_both_true,result_both_not_true)
[/tt]


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[kdr1974]

Many thanks
Kyle

 

[dallen43]

Shouldn't that be...

=if(first_expression,if(second_expression,result_both_true,result_second_not_true),result_first_not_true)
or
=if(and(first_expression,second_expression),result_both_true,result_any_not_true)