Nested IF with IFERROR

[detriez]

I am trying to populate the current cell as follows while keeping the IFERROR statement
My logic is:
If H7="BASIC" then current cell ="BASIC"
If H7=<1 then current cell ="HYB"
Else H7/G7*100

This will only work on error or if H7=BASIC

=IFERROR((IF(H7="BASIC","BASIC",IF(H7<1,"HYB"))(H7/G7*100)),0)

 

[dreid1011]

How about this:

=IFERROR(IF(H7="BASIC","BASIC",IF(H7<1,"HYB",(H7/G7)*100)),0)

 

[oldbrewer]

try doing it in helper cells on the sheet

=if(iserror(if(h7="basic","basic",if(h7<1,"hyb",h7/g7*100))),"error",if(h7="basic","basic",if(h7<1,"hyb",h7/g7*100)))

then put the value wherever with your macro

 

[detriez]

Both of these mostly work. I need the current cell to be 0 if H7 is blank. Right now it populates with "HYB"

 

[dreid1011]

Then perhaps this:

=IFERROR(IF(H7="BASIC","BASIC",IF(H7<1,"HYB",IF(H7="",0(H7/G7)*100))),0)

 

[detriez]

Excel auto corrected to this which returned "FALSE" in the current cell

=IFERROR(IF(H7="BASIC","BASIC",IF(H7<1,"HYB",IF(H7="",0[COLOR=#ff0000]*[/COLOR](H7/G7)*100))),0)

I tried this but, it didn't work either

=IFERROR(IF(H7="BASIC","BASIC",IF(H7<1,"HYB",IF(H7="",0[COLOR=#ff0000],[/COLOR](H7/G7)*100))),0)

 

[detriez]

This works!
I changed the order of the evaluation of H7.. not sure why but, it works. Thanks for your help guys

=IFERROR(IF(H7="BASIC","BASIC",IF(H7="",0,IF(H7<1,"HYB",(H7/G7)*100))),0)