isblank formula queston

[gripper]

I have a spreadsheet and in a particular cell I have this formula:

=CONCATENATE("http://www.",Inventory!C5)

I am trying to make the cell empty if Sheet "Inventory!C5) is empty.

I tried =if(isblank(inventory!c5,""

Then I got stuck and confused on what is next. I think I am on the right track just need a little nudge in the right direction.

Any assistance would be greatly appreciated.

Thanks

 

[jeffreybrown]

Looks like you need to close the function

Try...

Isblank(inventory!c5)

 

[shg]

Try

=if(isblank(inventory!c5), "", "http://www." & Inventory!C5)

The underlines are compliments of the forum.

 

[T. Valko]

I have a spreadsheet and in a particular cell I have this formula:

=CONCATENATE("http://www.",Inventory!C5)

I am trying to make the cell empty if Sheet "Inventory!C5) is empty.

I tried =if(isblank(inventory!c5,""

Then I got stuck and confused on what is next. I think I am on the right track just need a little nudge in the right direction.

Any assistance would be greatly appreciated.

Thanks

Try this...

=IF(Inventory!C5="","","http://www."&Inventory!C5)