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
Hello,

I will try to explain the best I can,

I have some cells 'A1, A2, A3, A4' that I fill up daily with numbers

ex:
-day1 I will input in 'A1',100$
-day2 I will input in 'A2', 94$
-day3 I will input in 'A3', 98$
-day4 I will input in 'A4', 96$

Now I have 3 more cells:
- 'B1=A1-A2'
- 'B2=A1-A3'
- 'B3=A1-A4'

And here comes the question:

I have cell 'C1' that needs to be B1 in day 2, then B2 in day 3 and B3 in day 4.

Ex:
C1 for day1=0$, day2=6$, day3=2$ and day4=4$

Hope I am not asking for too much.

Thank you in advance for your help

3 responses

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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
3
Pupic4fun Posts 2 Registration date Sunday August 15, 2021 Status Member Last seen August 29, 2021
Aug 29, 2021 at 11:33 AM
excelent... thanks you
0
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Aug 30, 2021 at 11:35 AM
Happy to help!
0
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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
0
Srry but it's not working
0
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555 > Pupic4fun
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
0
Pupic4fun 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
0