Forum Discussion
Formula based on sheet calculations?
For example, I have one sheet/tab called "Items" with rows for many item names listed in column A, a value in column B, and want to get a result in column C from a calculation. (there are other thin...
Another way of stating...
If task 1 was to mail Christmas cards to family, the tasks would be something like "verify address", "put card in envelope", "address it", "put a stamp on it",
If task 2 was to mail cards to friends, same tasks, but different # of people.
If task 3 was to mail cards to coworkers, etc...
And imagine there were 200 tasks and 70 steps per task.
Now that that's all set up, seems like the formula needs to get updated (hopefully in 1 place), because I forgot to factor in overseas addresses/postage, so it might have some conditional junk in the calculation later.
Thanks for looking.
If task 1 was to mail Christmas cards to family, the tasks would be something like "verify address", "put card in envelope", "address it", "put a stamp on it",
If task 2 was to mail cards to friends, same tasks, but different # of people.
If task 3 was to mail cards to coworkers, etc...
And imagine there were 200 tasks and 70 steps per task.
Now that that's all set up, seems like the formula needs to get updated (hopefully in 1 place), because I forgot to factor in overseas addresses/postage, so it might have some conditional junk in the calculation later.
Thanks for looking.
So, what you are looking for is a lambda function?
https://support.microsoft.com/en-us/office/lambda-function-bd212d27-1cd1-4321-a34a-ccbf254b8b67
https://support.microsoft.com/en-us/office/lambda-function-bd212d27-1cd1-4321-a34a-ccbf254b8b67