# 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.

## 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
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
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
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Aug 30, 2021 at 11:35 AM
Happy to help!
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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
Srry but it's not working
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
Hi Pupic4fun,

Well, it works for me, so let me post my workbook with the presented data in it as well as the formula: