How can I change a cell daily
Solved/Closed
Pupic4fun
-
Aug 6, 2021 at 08:56 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Aug 30, 2021 at 11:35 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Aug 30, 2021 at 11:35 AM
Related:
- How can I change a cell daily
- How to change date format in excel - Guide
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
- Can i change my outlook email address without creating a new account - Guide
- How to change close friends story to public - Instagram Forum
- Change computer name cmd - Guide
3 replies
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
544
Aug 24, 2021 at 11:32 AM
Aug 24, 2021 at 11:32 AM
Hi Pupic4fun,
Here you go:
=IF(A2="",0,IF(A3="",B1,IF(A4="",B2,IF(A5="",B3,IF(A6="",B4,IF(A7="",B5,B6))))))
Best regards,
Trowa
Here you go:
=IF(A2="",0,IF(A3="",B1,IF(A4="",B2,IF(A5="",B3,IF(A6="",B4,IF(A7="",B5,B6))))))
Best regards,
Trowa
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
544
Aug 9, 2021 at 12:26 PM
Aug 9, 2021 at 12:26 PM
Pupic4fun,
What a fun little question, I've definitely asked for a whole lot more.
Here is the requested formula:
=IF(A2="",0,IF(A3="",B1,IF(A4="",B2,B3)))
Best regards,
Trowa
What a fun little question, I've definitely asked for a whole lot more.
Here is the requested formula:
=IF(A2="",0,IF(A3="",B1,IF(A4="",B2,B3)))
Best regards,
Trowa
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
544
>
Pupic4fun
Aug 17, 2021 at 11:40 AM
Aug 17, 2021 at 11:40 AM
Hi Pupic4fun,
Well, it works for me, so let me post my workbook with the presented data in it as well as the formula:
https://wetransfer.com/downloads/9e25c66663eb32f8fb020335f6ab494820210817153915/1e27f9
Best regards,
Trowa
Well, it works for me, so let me post my workbook with the presented data in it as well as the formula:
https://wetransfer.com/downloads/9e25c66663eb32f8fb020335f6ab494820210817153915/1e27f9
Best regards,
Trowa
Pupic4fun
Posts
2
Registration date
Sunday August 15, 2021
Status
Member
Last seen
August 29, 2021
Aug 18, 2021 at 12:43 AM
Aug 18, 2021 at 12:43 AM
Ok.... your workbook works... can you do a 7 days for me? Please
Aug 29, 2021 at 11:33 AM
Aug 30, 2021 at 11:35 AM