Checkmark

[meg111]

I would like to create a formula that will display whether there is or is not data in a row. My formula is =COUNTA(B3:G3). How do I make this formula to either produce a checkmark if there is text in one of these cells or not rather than a number?

 

[FryGirl]

Try this then format the cell as font Marlett

=IF(COUNTA(B3:G3),"a","")

 

[meg111]

Thank you!!

 

[FryGirl]

You're welcome!