Quote Originally Posted by mikeTRON View Post
You did not frame your question or answer very well.

Low is subjective, not an actual number.


What are you looking to produce? I am not clear what you are trying to accomplish. It seems your question is simply a nested if but I cannot tell...

OK, lets try again.

background, i am copying information and pasting it in the the cells A-B-C-D
what i need is to have a formula to check if "F" is high or low (i will type in this manually )
If high, then check same row and Cell in "E" if there is a negative number,
if yes then write down "Fail" in row G and if NO then type "OK"

it will also check if for example it says low, then it first checks for a negative sum, ok on that, and if not "fail".

basicly it is

<check High/low>
>If high ->Check for negative sum
IF NO - > OK
IF Yes ->Fail

>If Low->Check for negative sum
IF Yes- > OK
IF No->Fail