Excel formula problems

Did you miss an attachment?

Thanks.
Its attached now
Excel-Formulas-Issues.xlsx

Okay, I've made the corrections in row 29 for you. (Max. risk for asset.) Unfortunately, I'm suffering from flu and need sleep and the other formulas are a bit too complicated for my brain to tackle at the moment! :-) Hopefully in the morning, if someone else hasn't already done those I can help you out with the rest!

If my Max. risk for asset formulas work out for you, I'd appreciate partial credit for those even if someone else jumps in and does the whole thing for you.. I'm short a few points to keep my qualified status for the month!

Here's the spreadsheet back at ya..
Excel-Formulas-Issues.xlsx

Hi Miss Sellaneous.  Sorry your not well. The copy of the file you attached didnt have any change to the row 29 formula.

To elimincate error in the formula use =IFERROR(yourformula,"")

To get the max risk, try this one.

=IF(SUMPRODUCT(--ISNUMBER(SEARCH({"high","medium","low"},B$23:B$28))),IF(COUNTIF(B$23:B$28,"high"),"High",IF(COUNTIF(B$23:B$28,"medium"),"Medium","Low")),"")

I'm sure there may be an easier one.

Kris

AARGGGHHHH!! I just saw the one I had made changes to listed in my recent documents, with a time after 9pm, but then I downloaded the one I had uploaded to you last night to check it, and it overwrote the one with changes, and now it is back to the original one with a time about 2 hours earlier!

I will get on this ASAP and CHANGE THE FILE NAME before uploading it again!!

Sorry..

Okay, I have started by analysing cell C24 on the Input & Results sheet. After I removed the redundant referenece to the current worksheet to improve readability, I noticed that you are trying to MATCH on C5&C6 (concatenated). C5&C6 calculates to "LowAlmost certain", and since there is no match to the string "LowAlmost certain" anywhere in the entire worksheet I think that's the reason you're getting an error.

Perhaps it would be easier if you  tell us in more detail what you are trying to lookup using what values.

Thanks Rgonzo1971 (and others)
All fixed.  New formulas suggested worked for Max Risk. Do you know why my use of IF function didnt work to find Max Risk.  If Im doing something wrong would be good to know, as often need to use IF statement

Lots of good responses.  Thanks
Have tried to split points in consideration of completeness and timing of response and simplicity of solution

The accepted as well as the assisted solution gives error and Low respectively, in case if there is no match found. And you simply ignore my solution - the first one !

Hi krishnakrkc
In my case there would always be a match.
Yes, yours was the first correct one but the formula was a tad long. So I didnt end up using it.
Its hard to score when muliple answers come in that address my queries.
Thanks for your efforts.