ExcelBanter - View Single Post

Thanks for the help it a great help

"Max" wrote:

"ballastrae" wrote
Thanks for the help. It was great!!!!!!!! Thanks for the file.

You're welcome !

I was looking on the site for how to do if their was a way to do for
pass/fail for certain sections if you can help with this.

Guess you mean *write* the comparison results of E9:G9 against the limits
out (we did this earlier using the 3 conditional format formulas)

For the same sample set-up,
we could put in say, I9:

=IF(AND($C9<"",$D9<"",E9=$C9,E9<=$D9),"Pass",
IF(AND($C9<"",E9<"",E9<$C9),"Under",
IF(AND($D9<"",E9$D9),"Over","")))

then copy I9 to K9

The above will yield in I9:K9, the results: Under, Pass, Over

Adapt the checking status messages: "Under", "Pass", "Over" to suit ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---