I need to calculate an answer for multiple cells in one cell

[Dabomb123!]

This applies for rows 4-8...

E4 calculation will equal d4-c4. If either c4 or d4 is blank then e4 will remain blank. If e4 is greater than or less than 8 they need to input a reason in f4.

If e4 is more or less than 8 AND there is no reason in f4 then an error needs to be displayed in G4. G4 is blank if E4 is 8 and F4 is blank.

Same thing from row 4 to 8.

What I cannot figure out, is I want F11 to show the errors that would show in f4-f8. So, instead of having a whole column of errors in column G, just show it in cell F11. I am attaching a sample model sheet.

 

[Fluff13]

Cross posted

Help with formula

Let's say I have cells E5 - E10 and F5 - F10. I want a message to appear in cell F11 that basically says "if the value in any cell E5-E10 is 8 and E5 - E10 are blank then display message 'check cells' but of E5 - E10 = 8 then cells F5 - F10 can be blank but if the values in cells E5 - E10 are...

www.mrexcel.com

and

I know this will be easy for most....

Cross-posted at https://www.mrexcel.com/board/threads/help-with-formula.1198426/ --6SJ And here: https://www.excelguru.ca/forums/showthread.php?11478-I-know-this-will-be-easy-for-most (AliGW) And here...

www.excelforum.com

 

[p45cal]

and https://www.excelguru.ca/forums/showthread.php?11478-I-know-this-will-be-easy-for-most

 

[vletm]

Dabomb123!
Please, reread Forum Rules

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

There are clear sentences about Cross-Posting.
... and same kind of rules are everywhere.