How do I make this cell go blank when other cells are blank

[Brew]

how do I make this formula produce an empty cell in H when AF:AH are empty:
=IF(OR(E796<10,E796>27),E796,MOD(E796-1,9)+1)

I try the following but it is missing something:
=IF(SUMPRODUCT(LEN(AF796:AH796)+0)=0,""(OR(E796<10,E796>27),E796,MOD(E796-1,9)+1)

 

[Aladin Akyurek]

Re: How do I make this cell go blank when other cells are bl

Given the spec...

=IF(COUNT(AF796:AH796),IF(OR(E796<10,E796>27),E796,MOD(E796-1,9)+1),"")

 

[Brew]

This is good, but what if AF:AH are all equal but not blank, like all 5s (5,5,5)?
Also, the answer returned a #Value, instead of an empty cell.

 

[Aladin Akyurek]

This is good, but what if AF:AH are all equal but not blank, like all 5s (5,5,5)?
Also, the answer returned a #Value, instead of an empty cell.

What do you have in AF796:AH796 -- text, numbers?

BTW, the formula should have been:

=IF(COUNT(AF796:AH796),IF(OR(E796<10,E796>27),E796,MOD(E796-1,9)+1),""),"")

meaning if no true numbers in AF796:AH796, give "", otherwise do: IF(OR(E796<10,E796>27),E796,MOD(E796-1,9)+1),"").

 

[Brew]

Re: How do I make this cell go blank when other cells are bl

Thanks Aladin. It works