If Function
Closed
hjmarshall
Posts
1
Registration date
Tuesday September 10, 2013
Status
Member
Last seen
September 10, 2013
-
Sep 10, 2013 at 09:50 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Sep 10, 2013 at 11:24 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Sep 10, 2013 at 11:24 AM
Related:
- If Function
- Find function on mac - Guide
- Accessor function c++ - Guide
- Spreadsheet function - Guide
- Agp function - Guide
- Hard drive function - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Sep 10, 2013 at 11:24 AM
Sep 10, 2013 at 11:24 AM
Hi Hjmarshall,
Return Y in cell X1 if y is found in range A1:G1, then use:
=IF(COUNTIF(A1:G1,"y")>0,"Y","")
Best regards,
Trowa
Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.
Return Y in cell X1 if y is found in range A1:G1, then use:
=IF(COUNTIF(A1:G1,"y")>0,"Y","")
Best regards,
Trowa
Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.
