ExcelBanter - Return Blank

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Return Blank (https://www.excelbanter.com/excel-discussion-misc-queries/208963-return-blank.html)

Jim

Return Blank

Hello,

What formula do I use to return a blank cell id a1:e1 are all blank?

Thanks

Gary''s Student

Return Blank

=IF(A1&B1&C1&D1&E1="","","not all are blank")
--
Gary''s Student - gsnu200811

All times are GMT +1. The time now is 07:40 AM.