How can I change a cell daily

[Solved]
Report
-
Posts
2817
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 14, 2021
-
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

Posts
2817
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 14, 2021
486
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
Thank you

Glad we were able to help! Love us? Write us a review! Rate CCM

CCM 2821 users have said thank you to us this month

Posts
2
Registration date
Sunday August 15, 2021
Status
Member
Last seen
August 29, 2021

excelent... thanks you
Posts
2817
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 14, 2021
486
Happy to help!
Posts
2817
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 14, 2021
486
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
Srry but it's not working
Posts
2817
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 14, 2021
486 > Pupic4fun
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
Posts
2
Registration date
Sunday August 15, 2021
Status
Member
Last seen
August 29, 2021

Ok.... your workbook works... can you do a 7 days for me? Please