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 December 27, 2022 - Aug 30, 2021 at 11:35 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Aug 30, 2021 at 11:35 AM
Related:
- How can I change a cell daily
- Change computer name cmd - Guide
- Can i change my free fire facebook account to google account - Guide
- How to change language in kmplayer - Guide
- Change lg tv name - Guide
- Can i change my phone number t mobile - Guide
3 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
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
December 27, 2022
552
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
December 27, 2022
552
>
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