How can I change a cell daily

Solved
Pupic4fun - Aug 6, 2021 at 08:56 PM
TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 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 replies

TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
509
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
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
509
Aug 30, 2021 at 11:35 AM
Happy to help!
0
TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
509
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
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
509 > 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