formula IF non work

[max_max]

Hi to all,
this formula works

=IF(B4="","",IF(B4<d4,2,if(b4>D4,1,IF(B4=D4,"X")))) (english)

=SE(B4="";"";SE(B4<d4;2;se(b4>D4;1;SE(B4=D4;"X")))) (italiano)

this formula not work

=IF(B4="",D4="","",IF(B4<d4,2,if(b4>D4,1,IF(B4=D4,"X"))))

=SE(B4="";D4="";"";SE(B4<d4;2;se(b4>D4;1;SE(B4=D4;"X"))))

where am I wrong?
max_max</d4;2;se(b4></d4,2,if(b4></d4;2;se(b4></d4,2,if(b4>

 

[etaf]

are you trying to say
both B4 AND D4 = "" to be a ""
or
B4 OR D4 could = "" to be a ""

=IF(AND(B4="",D4=""),"",IF(B4<d4,2,if(b4 style="color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">D4,1,IF(B4=D4,"X"))))
</d4,2,if(b4>

=IF(OR(B4="",D4=""),"",IF(B4<d4,2,if(b4 style="color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">D4,1,IF(B4=D4,"X"))))

</d4,2,if(b4>what are you trying here
IF(B4<d4,2,if(b4 style="color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">D4

</d4,2,if(b4>can you explain what you want to happen

 

[Fluff]

Canceled

 

[max_max]

Hi etaf,
my formula correct is:

= IF ( B4 = "" , "" , IF ( B4 > D4 , 1 , IF ( B4 = D4 , "X" ) ) ) )

your formula is correct

<d4,1,if(b4=d4,"x")))
<d4,1,if(b4=d4,"x"))))
= IF ( AND ( B4 = "" , D4 = "" ) , "" , IF ( B4 > D4 , 1 , IF ( B4 = D4 , "X" ) ) )
or </d4,1,if(b4=d4,"x"))))
</d4,1,if(b4=d4,"x")))

<d4,1,if(b4=d4,"x")))
<d4,1,if(b4=d4,"x"))))
= IF ( OR ( B4 = "" , D4 = "" ) , "" , IF ( B4 > D4 , 1 , IF ( B4 = D4 , "X" ) ) )

thanks you
max_max</d4,1,if(b4=d4,"x"))))





</d4,1,if(b4=d4,"x")))

 

[etaf]

you should have a false for b4 < d4

= IF ( OR ( B4 = "" , D4 = "" ) , "" , IF ( B4 > D4 , 1 , IF ( B4 = D4 , "X" , "b4 is less d4")) ) )

 

[max_max]

Copy an paste not work

correct is:
= IF ( OR ( B4 = "" , D4 = "" ) , "" , IF ( B4 > D4 , 1 , IF ( B4 = D4 , "X" , IF ( B4 < D4 , 2 ) ) ) )

max_max

 

[etaf]

= IF ( OR ( B4 = "" , D4 = "" ) , "" , IF ( B4 > D4 , 1 , IF ( B4 = D4 , "X" , IF ( B4 < D4 , 2 ) ) ) )

you dont need the last if

= IF ( OR ( B4 = "" , D4 = "" ) , "" , IF ( B4 > D4 , 1 , IF ( B4 = D4 , "X" , 2 ) ) )

as if b4 does not = or is not > then
it must be less then

 

[max_max]

Thanks etaf

= IF ( OR ( B4 = "" , D4 = "" ) , "" , IF ( B4 > D4 , 1 , IF ( B4 = D4 , "X" , 2 ) ) )

it is OK.
A greeting max_max