nested IF formula

[ADAMC]

Hi all,

Can anyone help me with a formula for the following please?

If H1 isn't blank do nothing, if it is then G1, but if G1 AND H1 are blank show "error"

Thank you

 

[snjpverma]

Try this

=IF(LEN(G1&H1),IF(H1="",G1,"nothing"),"Error")

 

[ADAMC]

Try this

=IF(LEN(G1&H1),IF(H1="",G1,"nothing"),"Error")

Great,

thanks very much for the help!

 

[Sebyq]

Hi all,

Can anyone help me with a formula for the following please?

If H1 isn't blank do nothing, if it is then G1, but if G1 AND H1 are blank show "error"

Thank you

When you say "If H1 isn't blank do nothing" do you mean to return the value on H1, or leave the formula return "" , or the formula to return the word "nothing"?

 

[Sebyq]

When you say "If H1 isn't blank do nothing" do you mean to return the value on H1, or leave the formula return "" , or the formula to return the word "nothing"?

You can also use

=IF(H1<>"","",IF(AND(G1="",H1=""),"Error",G1)) - that will leave it blank if H1 isn`t blank or

=IF(H1<>"","Nothing",IF(AND(G1="",H1=""),"Error",G1)) - will return "Nothing" if H1 isn`t blank

 

[ADAMC]

Thanks Sebyq,

You are correct I actually meant if H1 isn't blank then return H1

 

[Sebyq]

Thanks Sebyq,

You are correct I actually meant if H1 isn't blank then return H1

in that case change "nothing" in the formula to H1 - like below.

So If H1 is not blank(has a value) return the value in H1, if G1 and H1 is blank than return "Error", if the first 2 are false then return the value of G1.

=IF(H1<>"","H1",IF(AND(G1="",H1=""),"Error",G1))

 

[snjpverma]

What values do you have in H1 and G1, are they numbers or text?

 

[snjpverma]

My Post #2 formula modified as per your requirement.

=IF(LEN(G1&H1),IF(H1="",G1,"H1"),"Error")