How to Return blank if not true? =IF(D466="Fog",CONCATENATE(B466," ",C466*E466,"Mg"))

[Peptide]

Hello -
I have this formula but would like the cell to return blank if D466 is not equal to Blue. Pretty sure it needs IFERROR but can't get it to work... ugh

=IF(D466="Blue",CONCATENATE(B466," ",C466*E466,"Mg"))

Thanks in advance!

 

[Fluff]

How about
=IF(D466<>"Blue","",CONCATENATE(B466," ",C466*E466,"Mg"))

 

[Rick Rothstein]

Hello -
I have this formula but would like the cell to return blank if D466 is not equal to Blue. Pretty sure it needs IFERROR but can't get it to work... ugh

=IF(D466="Blue",CONCATENATE(B466," ",C466*E466,"Mg"),"")

You only provided the TRUE part of the IF function... just add the FALSE part as shown in red above.

 

[Peptide]

Thank you Rick - its always the small things. Very much appreciated!

Bob