=IF(E10<D10,"U","F") how to modify adding "Blank&quo 3

[TonyU]

Hello all, can someone please help me in modifying this formula

=IF(E10<D10,&quot;U&quot;,&quot;F&quot

to display blank is nothing populates cells E10 and D10
right now, the letter F show's up when both cells are blank.

Thanks in advanced...

 

[xlbo]

specifically from what you have requested:
=IF(AND(E10=&quot;&quot;,D10=&quot;&quot,&quot;&quot;,if(E10<D10,&quot;U&quot;,&quot;F&quot)

if you want to check whether EITHER is empty, use:

=IF(OR(E10=&quot;&quot;,D10=&quot;&quot,&quot;&quot;,if(E10<D10,&quot;U&quot;,&quot;F&quot)


Rgds, Geoff
Si hoc legere scis, nimis eruditionis habes
Want the best answers to your questions ? - then read me baby one more time - faq222-2244

 

[luceze]

Try This

=IF(E10+D10=0,&quot;&quot;,IF(E10<D10,&quot;U&quot;,&quot;F&quot)

HTH,
Eric

 

[Wray69]

try this

=IF(AND(ISBLANK(E10),ISBLANK(F10)),&quot; &quot;,IF(E10<F10,&quot;U&quot;,&quot;F&quot)

Wray

 

[TonyU]

Thank you both very much...

 

[TonyU]

Thank you also Wray69