If Formula

[thbutterflycollector_]

Hi,

In cell R66 I am trying to return a blank cell if the J66 is also blank. I currently have the following formula:

=IF(S66="No",J66,"Reference"&"_"&J66&Q66)

In cell R66 I have "Reference" and would like this to be blank.

Can anyone assist?

 

[etaf]

is that formula in cell R66 ???
confused
where is that formula

in R66
=IF( J66="", "" , ??? not sure what is here - possible - IF(S66="No",J66,"Reference"&"_"&J66&Q66))

 

[Fluff]

How about

=if(j66="","",IF(S66="No",J66,"Reference"&"_"&J66&Q66))

 

[thbutterflycollector_]

How about

=if(j66="","",IF(S66="No",J66,"Reference"&"_"&J66&Q66))

This works. Thank you.

 

[Fluff]

Glad we could help & thanks for the feedback.