Forum Discussion

Copper Contributor

Jul 16, 2021

Solved

Excel - Risk Rating calculation using "If(or)" function

I have copied this formula - =@IF(OR($M10="",$L10=""),"",INDEX(Matrix_Rating,MATCH($M10,Matrix_Likelihood,0),VALUE(LEFT($L10)))) from one Excel spreadsheet to another to perform the same Risk Rating...

Copy of WRAC JB.xlsx811 KB

Formulas and Functions

Yea_So
Jul 18, 2021
Jblake998
This is the workbook that i sent on my response, and it works. Isn't it the right value?

Jblake998

Copper Contributor

Jul 18, 2021

Yea_So

Hello Yea,

Thanks for that doing this for me.

When I put the formula into the first Risk rating cell "Y15" and press enter the following error message comes up. Can you send back the document that you have corrected please.

Yea_So

Bronze Contributor

Jul 18, 2021

Jblake998

This is the workbook that i sent on my response, and it works. Isn't it the right value?

Yea_So
Bronze Contributor
Jul 18, 2021
Jblake998

You are very welcome John.

Cheers
Jblake998
Copper Contributor
Jul 18, 2021
Thank you so much.
I really appreciate your help.
😊
Yea_So
Bronze Contributor
Jul 18, 2021
Jblake998

1,000,000.00 lol, just mark the post as the best answer. Thank you

Cheers
Jblake998
Copper Contributor
Jul 18, 2021
hello Yea,

Sorry I didn't see the attachment. it is very small.
I am happy to pay you for your time.
How much do I owe you please.