How to use =IF(ISBLANK) & =TEXT

[Yotafan]

I get =TEXT(B3,"000-000-0000") to work and format the cell the way i want.

I also get =IF(ISBLANK(B4),"none",B4) to work the way i want.

But how would i format the cell in the above format if it contains a value, then if it is blank to display "none".


TIA
Ed

 

[JoeMo]

Maybe:

=IF(ISBLANK(B4),"none",TEXT(B4,"000-000-0000"))

 

[Yotafan]

Maybe:

=IF(ISBLANK(B4),"none",TEXT(B4,"000-000-0000"))

Thank you sir'that worked like a charm.