Get a Previous Cells value and add it to current cell

4 posts / 0 new
Last post
rahulsaxena3
Offline
Joined: 01/09/2018 - 14:02
Get a Previous Cells value and add it to current cell

Hi Brian,If i want get a cells value & then add it to the preious cell and keep on populating a column like that. Would it be possible ? For eg. in MS Excel, the same formula would like this = Coln A | Coln B| Coln C| 12               2             22               4            coln C = 12 + 4 = 16  ----- i.e. -->   A1 + B2 = C2                                                                                                A2 + B3 = C3                                                                                                       etc.In excel it is possible to do this due to cell references. But will i be able to do it in IDEA, which works with columns & not cells ?
 
A1 + B2 = C2
A2 + B3 = C3
A3+B4=C4
 
etc.... how do i populate a column C like that ^

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Hi Rahul, just want to make sure that this is the same question that you sent to CaseWare?  I just want to make sure it got answered.

Thanks

ernesto
Offline
Joined: 11/12/2021 - 09:05

I'd like to do the same. I've already learned how to capture and verify the value of the current cell I'm observing, however I'd like to change a previous cell based on that information. However, I don't know what to do.

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Could you explain more in detail what you are trying to do.