help me write a formula please - maybe IF?

[hawilder]

Hello - I want to write a formula to do the following:

If F3 has a number in it than tell me if M3 is blank.

<colgroup><col width="72"></colgroup><tbody>
[TD="width: 72"][/TD]

</tbody>

in other words... you have to be doing the criteria we have in one column if you want to sell the product in the other column...

Any help is appreciated. Thank you.

 

[tyija1995]

Hey try this:

=IF(ISNUMBER(F3)=TRUE,IF(ISBLANK(M3),"M3 is blank","M3 is not blank"),"F3 does not contain a number")

EDIT: If you want a more dynamic result output instead of a static "M3 is blank" for example then use the below adapted formula:

=IF(ISNUMBER(F3)=TRUE,IF(ISBLANK(M3),SUBSTITUTE(CELL("address",M3),"$","")&" is blank",SUBSTITUTE(CELL("address",M3),"$","")&" is not blank"),SUBSTITUTE(CELL("address",F3),"$","")&" does not contain a number")