Formula Required

[ShoaibAli]

Looking for 1 more resolution.

I want a formula looks like below result.

Formula Result =
Kashif (1-Wed-Late-9.00 " Domestic Issue ") * (2-Thu-Absent " Exam ") * (8-Wed-Absent " Exam ") * (14-Tue-Leave " Health Issue ") * (20-Mon-Late-10.00 " Traffic ") * (27-Mon-Leave " Health Issue ") * (29-Wed-Late-11.00 " Traffic ") End

 

[Larry Haydn]

How can you multiple time and text?

 

[ShoaibAli]

Larry Haydn

This isn't time it is numeric value such as 1.23, 2.3

but i consider them as time.

 

[Peter_SSs]

This isn't time it is numeric value such as 1.23, 2.3

How does 1.23 or 2.3 relate to what you posted in post #1?

 

[ShoaibAli]

Sir these are numbers but i am considering as time.

 

[jasonb75]

So let me get this straight, you want to see this as a text string in a single cell based on the contents of C3:E33?

Kashif (1-Wed-Late-9.00 " Domestic Issue ") * (2-Thu-Absent " Exam ") * (8-Wed-Absent " Exam ") * (14-Tue-Leave " Health Issue ") * (20-Mon-Late-10.00 " Traffic ") * (27-Mon-Leave " Health Issue ") * (29-Wed-Late-11.00 " Traffic ") End

In terms of possibility and practicality I believe that it falls somewhere between shooting the moon with a water pistol and teaching a goldfish to play a piano.

Noting that your account profile lists almost every version of excel yet your screen capture appears to be google sheets, you are making it impossible for people to help you.

 

[ShoaibAli]

I am using Excel 2016 and also google sheets. i have tried to change the Excel versions list mentioned in my profile but do not know how.

If it is possible for you to make formula for single cell then i will prolong it to till end.

If TEXT values cannot be figured then please suggest me something other.

before i was using this formula

=TRIM("Late Comers, "&" "&C3&", "&G3&", "&K3&", "&O3&", "&S3&", "&W3&", "&AA3&", "&AE3&", "&AI3&", "&AM3&", "&AQ3&", "&AU3&", "&AY3&", "&BC3&", "&BG3&", "&BK3&", "&BO3&", "&BS3&", "&BW3&"")

 

[ShoaibAli]

before i was using this formula that was created to get result at the end of the row.

and now changed the sheet pattern and want the perfect formula at the end of the columns.

 

[ShoaibAli]

Please look at the example that i have made

=C1&"=> "&IF(C3<>TEXT(C3,"H:MM AM/PM"),"Late - ")&IF(OR(C3<>"",D3<>""),TEXT(A3,"MM/DD/YY - "))&IF(OR(C3<>"",D3<>""),TEXT(TODAY(),"DDDD - ")&IF(E3<>"",E3))

just need to add the L=Leave and A=Absent in the formula.

I have changed the format and working perfectly please prolong it till the end of the row.

but when i erase the data it becomes like this

 

[jasonb75]

i have tried to change the Excel versions list mentioned in my profile but do not know how.

Click on your user name at the top right of the page, then 'Account Details'. Scroll down and change the checkboxes to show the correct versions, then save changes at the bottom.

If you need solutions that will work in google sheets then it would be better if you post your questions in the 'other applications' section of the forum rather than the excel questions section.

Other helpers may think differently but I don't see that what you want will be possible with a formula that will work with 2016 / google sheets other than extending your existing formula to cover the whole range which you will need to do for each cell, not as an array. To prevent FALSE from showing you need to enter "" into the FALSE arguments of your IF functions.