Need help with this Formula

  • Thread starter Thread starter Sharon
  • Start date Start date
S

Sharon

Could anyone help me change the following formula so it ONLY shows up
if data is entered in the other columns that this column pulls data
from? Right now it is showing the @k12sbr.org in the cells, but I
don't want the cells to show anything if no data is entered yet on the
spreadsheet. I know I should add the =IF to the beginning, but I get
lost after that.

Thanks for your help!

=LOWER(LEFT(C3,1)&LOWER(D3)&RIGHT(E3,4)&"@k12sbr.org")

Sharon
 
Check the length of each cell. Multiplying by zero always equals zero...
=IF(LEN(C3)*LEN(D3)*LEN(E3)>0,LOWER(LEFT(C3,1)&LOWER(D3)&RIGHT(E3,4)&"@k12sbr.org"),"")
--
Jim Cone
Portland, Oregon USA
http://tinyurl.com/ExtrasForXL add-in

..
..
..

"Sharon" <[email protected]>
wrote in message
Could anyone help me change the following formula so it ONLY shows up
if data is entered in the other columns that this column pulls data
from? Right now it is showing the @k12sbr.org in the cells, but I
don't want the cells to show anything if no data is entered yet on the
spreadsheet. I know I should add the =IF to the beginning, but I get
lost after that.
Thanks for your help!

=LOWER(LEFT(C3,1)&LOWER(D3)&RIGHT(E3,4)&"@k12sbr.org")

Sharon
 
And this relocation of a ")" might be closer to what you want...
=IF(LEN(C3)*LEN(D3)*LEN(E3)>0,LOWER(LEFT(C3,1))&LOWER(D3)&RIGHT(E3,4)&"@k12sbr.org","")
Jim Cone

..
..
..


"Jim Cone" <[email protected]>
wrote in message Check the length of each cell. Multiplying by zero always equals zero...
=IF(LEN(C3)*LEN(D3)*LEN(E3)>0,LOWER(LEFT(C3,1)&LOWER(D3)&RIGHT(E3,4)&"@k12sbr.org"),"")
 
Back
Top