Hi,

Im trying to put together a formula that looks at 3 different cells, and returns the cell that has data in it, and block from putting data in the other selection.

 IF ANY INFORMATION IS COMBINED IN CELL B2,B7,B9. an error will show

If B18 = 90 PUT 100% IN CELL b1, IF B25 = 40 PUT 100% IN CELL b1, IF B33 = 20 PUT 100% IN CELL b1, 0

Please see the attachment for more detailed information, please also look at both tabs to help understand

Thank you for your time and help

http://files.engineering.com/getfile.aspx?folder=f778a72d-c99c-4e8a-9d48-9e9a13cde35e&file=SCORING.xlsx

Hi,

My understanding is that there are three conditions : if B18 = 90, if B25 = 40, if B33 = 20, if one of them is true, B1 will display "100%". If none of them is true, B1 will display "error". Am I right? If yes, please try this formula and put it in B1:

=IF(OR(B18=90,B25=40,B33=20),100%,"error")

If I misunderstood something, please let me know.

Regards,