Home

Set initial value to a cell and then update it using a formula

%3CLINGO-SUB%20id%3D%22lingo-sub-744699%22%20slang%3D%22en-US%22%3ESet%20initial%20value%20to%20a%20cell%20and%20then%20update%20it%20using%20a%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-744699%22%20slang%3D%22en-US%22%3E%3CP%3EActivity%20%23%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BTotal%20Time%20(yesterday)%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20Time%20spent%20(today)%3C%2FP%3E%3CP%3E%26nbsp%3B1%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%204%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B2%3C%2FP%3E%3CP%3E%26nbsp%3B2%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%200%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B4%3C%2FP%3E%3CP%3E%26nbsp%3B3%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%203%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B5%3C%2FP%3E%3CP%3E%26nbsp%3B4%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%202%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B0%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20data%20similar%20to%20the%20one%20shown%20above.%20I%20want%20to%20update%20my%20total%20time%20for%20every%20activity%20based%20on%20the%20time%20spent%20(today).%20Initially%20I%20want%20to%20set%20the%20value%20of%20all%20the%20cells%20in%20Total%20Time%20to%20zero%20and%20then%20update%20it%20based%20on%20my%20data%20from%20today%20.%20So%20I%20want%20to%20write%20a%20formula%20that%20adds%20the%20time%20spent%20from%20today%20to%20current%20value%20of%20Total%20time%20from%20yesterday%20for%20every%20activity.%20i.e%3C%2FP%3E%3CP%3ETotal%20time%20(today)%20%3D%20Total%20Time%20(yesterday)%20%2B%20time%20spent%20(today)%3C%2FP%3E%3CP%3EOR%3C%2FP%3E%3CP%3Ex%20(current%20value)%20%3D%20x(initial%20value)%20%2B%20constant%3CBR%20%2F%3EIn%20other%20words%20I%20want%20to%20have%20a%20way%20to%20save%20the%20total%20time%20values%20from%20yesterday.%20With%20for%20Loop%20it%20is%20possible%20but%20I%20can%20not%20use%20VBA%20or%20Macros%20as%20I%20am%20working%20at%20excel%20online.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CBR%20%2F%3ERegards%2C%3C%2FP%3E%3CP%3ETayyab%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-744699%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-744720%22%20slang%3D%22en-US%22%3ERe%3A%20Set%20initial%20value%20to%20a%20cell%20and%20then%20update%20it%20using%20a%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-744720%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F373311%22%20target%3D%22_blank%22%3E%40MTayyab%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAfraid%20that%20doesn't%20work%20in%20Excel%20Online%20since%20you%20have%20circular%20reference%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-744761%22%20slang%3D%22en-US%22%3ERe%3A%20Set%20initial%20value%20to%20a%20cell%20and%20then%20update%20it%20using%20a%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-744761%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20develop%20a%20For%20Loop%20in%20excel%20using%20default%20available%20formulas%20(without%20VBA%20code)%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-745039%22%20slang%3D%22en-US%22%3ERe%3A%20Set%20initial%20value%20to%20a%20cell%20and%20then%20update%20it%20using%20a%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-745039%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F373311%22%20target%3D%22_blank%22%3E%40MTayyab%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETo%20my%20knowledge%20-%20no%3C%2FP%3E%3C%2FLINGO-BODY%3E
Deleted
Not applicable

Activity #     Total Time (yesterday)        Time spent (today)

 1                    4                                             2

 2                    0                                             4

 3                    3                                             5

 4                    2                                             0

 

I have a data similar to the one shown above. I want to update my total time for every activity based on the time spent (today). Initially I want to set the value of all the cells in Total Time to zero and then update it based on my data from today . So I want to write a formula that adds the time spent from today to current value of Total time from yesterday for every activity. i.e

Total time (today) = Total Time (yesterday) + time spent (today)

OR

x (current value) = x(initial value) + constant
In other words I want to have a way to save the total time values from yesterday. With for Loop it is possible but I can not use VBA or Macros as I am working at excel online. 


Regards,

Tayyab

3 Replies

@Deleted 

Afraid that doesn't work in Excel Online since you have circular reference

@Sergei Baklan 

Is there a way to develop a For Loop in excel using default available formulas (without VBA code) ?

@Deleted 

To my knowledge - no

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
12 Replies