How can I change a cell daily
Solved
Pupic4fun
-
Aug 6, 2021 at 08:56 PM
TrowaD
TrowaD
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Related:
- How can I change a cell daily
- Excel VBA – In a column, change only cells that - How-To - Excel
- How to change your cell phone number t mobile - Guide
- Change same cell in multiple sheets - Guide
- Changing a cell value based on the color of a ✓ - Forum - Office Software
- Excel drop down list change other cells ✓ - Forum - Excel
3 replies
TrowaD
Aug 24, 2021 at 11:32 AM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
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
Aug 9, 2021 at 12:26 PM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
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
Aug 17, 2021 at 11:40 AM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
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
Aug 18, 2021 at 12:43 AM
- Posts
- 2
- Registration date
- Sunday August 15, 2021
- Status
- Member
- Last seen
- August 29, 2021
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