Hi

I have a series of IF statements at the moment that also check if values are present in cells in other worksheets.

If there is no values I am passing back " " to the cell to get rid of it saying 0

However is there a way to pass back a command to be empty?

Here is a sample of one of the formulas

=IF(INDIRECT("'"&$Q$1&"'!C2")=""," ","Green")