AssignmentHelp
New Member
- Joined
- Apr 22, 2019
- Messages
- 1
Hello forums,
My problem is IÂ’m trying to recall multiple variables in a row to the end of a column. For example, my table will look like this:
A. B. C. D. E. F. G. H
1) Model. Worktop Time Door time Drawer Time Total subs
2). a. 0. 0m 1. 5m. 2 3m. Formula
3). b. 1. 5m. 2. 10m. 0. 0
4). c. 1. 0. 1. 5m. 2. 0
I have Models A, B, and C. Each model gets a sub assemblied piece added to it. (And some may not have a time). IÂ’m trying to write an if/then statement saying if there is a time >0, recall the value for that piece into the total sub cell. If there is no time, donÂ’t recall anything or recall 0. But i want to string it or nest it all into one formula.
So, the formula might look like this: =if(c2>0, then recall b2 into h2, else, recall 0 into h2, if(E2>0, recall D2 into H2, else, 0, if(etc....))).... and if i copied it paste it down the column it will change the formula according to whatever row itÂ’s in.
Ive tried [if/then(vlookup)], sumifs, counts; not really sure anymore.
I hope this makes sense. Thanks in advance.
EDIT: Sorry, didn’t realize my table would look like that after i submit it
My problem is IÂ’m trying to recall multiple variables in a row to the end of a column. For example, my table will look like this:
A. B. C. D. E. F. G. H
1) Model. Worktop Time Door time Drawer Time Total subs
2). a. 0. 0m 1. 5m. 2 3m. Formula
3). b. 1. 5m. 2. 10m. 0. 0
4). c. 1. 0. 1. 5m. 2. 0
I have Models A, B, and C. Each model gets a sub assemblied piece added to it. (And some may not have a time). IÂ’m trying to write an if/then statement saying if there is a time >0, recall the value for that piece into the total sub cell. If there is no time, donÂ’t recall anything or recall 0. But i want to string it or nest it all into one formula.
So, the formula might look like this: =if(c2>0, then recall b2 into h2, else, recall 0 into h2, if(E2>0, recall D2 into H2, else, 0, if(etc....))).... and if i copied it paste it down the column it will change the formula according to whatever row itÂ’s in.
Ive tried [if/then(vlookup)], sumifs, counts; not really sure anymore.
I hope this makes sense. Thanks in advance.
EDIT: Sorry, didn’t realize my table would look like that after i submit it
Last edited by a moderator: