Excel formula If A is true then check B and if B is negative then return

Hi,

I am looking for a little support,
i am making this list, where i need a formula that goes like this

IF cell F is Low then check for a negative number in cell E and if yes then mark cell G "OK"
IF cell F is low but a positive number then mark cell G "negative"

and
IF cell F is High but a positive number in cell E then mark cell G "OK"
IF cell F is High then check for a negative number and if yes then mark cell G "Negative

Software.xlsx"

Originally Posted by mikeTRON

What is LOW and where do you need this formula?

low and high is what is specify row F, do you mean what i need to use if for? or in what row?

Originally Posted by mikeTRON

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