Nested IF Query

[broncos347]

I am trying to work out a formula for the following

IF Column H = "Y" then the text "Not Rqd" is shown in Column K, however, if Column K = "N" and Column J>Column I then the text "Yes" is shown, however if Column K = N and Column J<Column I then the text "No" is shown.

i know this is probably a nested IF formula but I cannot for the life of me figure out how to do it, any help would be appreciated.

 

[JazzSP8]

<column i="" then="" the="" text="" "no"="" is="" shown.
Hi

I think you might have got muddled somewhere :-/
</column>

IF Column H = "Y" then the text "Not Rqd" is shown in Column K, however, if Column K = "N"

Is the second Column K supposed to refer to H again?

however if Column K = N and Column J

Uhm. What?

Assuming the K is supposed to be H then this might set you on the right path...

=IF(H1="Y","Not Rqd",IF(AND(H1="N",J1>I1),"Yes","Something Something"))

 

[broncos347]

JazzSP8, thanks for the reply, I probably could have written what i was looking for a bit better, here goes

IF H3="Y" then "Not Rqd"

IF H3="N", J3>=I3 then "Yes"

IF H3="N", J3<I3 then "No"

your formula almost worked except that when i amended your H1="N",J1>I1 formula to H1="N",J1>=I1 it didn't seem to work but knowing me its probably something that i've done.

 

[JazzSP8]

Try this...

=IF(H3="Y","Not Rqd",IF(AND(H3="N",J3>=I3),"Yes",IF(H3="N",J3,"")))

It shows as blank if none of the conditions are met

 

[broncos347]

JazzSP8, thanks works a treat.

 

[JazzSP8]

No problem, glad to have helped :D