Yes that works! :)

Can I ask if it is possible to add this formula to a number of cells in one
go that are already populated with the original and incorrect formula, so I
don't have to go back and enter your formula to some 200 cells indiviually?

"Teethless mama" wrote:

Assuming D5 either contain text or blank then try this:

=REPT('RP1'!D5,1)


"Scoober" wrote:

Opps i forgat to tell you that the forula in A1 is currently =RP1!D5

"Scoober" wrote:

Hi,

I am trying to find a way to leave a blank cell on my summary sheet that is
populated from another sheet within the worksheet.

i.e.
Summary page - A1 is populated from worksheet1 from D5

If D5 says 'Yes' then 'Yes' appears in A1 of my summary sheet

My question is how can I leave A1 blank if D5 is blank on worksheet1?

At the moment if D5 is Blank I get a '0' in A1 on my summary sheet which
does not visually very nice.

Thank you for your help in advance.