IF combined with additional text in quotes

[ollyhughes1982]

Hi all,

I am using the below formula, which includes a quoted parts that adds brackets and an x to the result of the second part of my formula.

=IF('All Completed VC'!$B$4="","",('All Completed VC - Levels'!N5 & " (x"&'All Completed VC - Levels'!B5))&")"

The result looks like this: Level 1 (x1)

Without the extra quoted parts it would look like this: Level 11

My problem is this, when 'All Completed VC'!$B$4 does equal "", the cell stills displays as follows: (x)

I want it so that when 'All Completed VC'!$B$4 does equal "", the cell appears empty. Currently, it takes away the actual formula results, but the additional text remains and I want to remove it for the "" results.

Thanks in advance!

Olly.

 

[etaf]

did you try my formula
=IF('All Completed VC'!$B$4="","",'All Completed VC - Levels'!N4 & " (x"&'All Completed VC - Levels'!B4&")" )

works
see cell B92
coloured light orange/pink

clear the cell in B4 and it goes blank

Dropbox - File Deleted - Simplify your life

www.dropbox.com

 

[ollyhughes1982]

This is now working, thanks everyone.

I used this formula: =IF('All Completed VC - Levels'!B4="","",'All Completed VC - Levels'!N4 & " (x"&'All Completed VC - Levels'!B4&")" )

Thanks again.

 

[Fluff]

Glad we could help & thanks for the feedback