Add value to one cell if multiple other cells have any value
Solved/Closed
alonsy
Posts
6
Registration date
Friday April 18, 2014
Status
Member
Last seen
April 21, 2014
-
Apr 18, 2014 at 03:38 PM
alonsy Posts 6 Registration date Friday April 18, 2014 Status Member Last seen April 21, 2014 - Apr 21, 2014 at 10:39 PM
alonsy Posts 6 Registration date Friday April 18, 2014 Status Member Last seen April 21, 2014 - Apr 21, 2014 at 10:39 PM
Related:
- Use the ifs function to return 5 if cell a5 contains the value 3, and return a 6 if it contains any other number.
- Gta 5 download apk pc - Download - Action and adventure
- Hitman 3 cheats - Guide
- If cell contains date then return value ✓ - Excel Forum
- Excel formula to check if cell contains a date - Excel Forum
- Psiphon 3 download - Download - VPN
2 responses
Hang in there, two questions:
What is already in G1? Is it a formula, or is it an integer input by the user?
Let us know!
What is already in G1? Is it a formula, or is it an integer input by the user?
Let us know!
Do you have the liberty of this?
alonsy
Posts
6
Registration date
Friday April 18, 2014
Status
Member
Last seen
April 21, 2014
Apr 18, 2014 at 08:43 PM
Apr 18, 2014 at 08:43 PM
Sorry, I'm not sure what this is...
Well, that is a screen shot of your solution. If you cannot reverse engineer your final product from this, then wait around and see if someone else in the forum can possible make it more simple. I am sorry I cannot communicate the answer to you.
If you look at the above picture, wou will see three columns, colum a has the values to check for. Column b is the actual formulas that give the valuesYOU PROVIDED IF THERE IS A VALUE IN EACH CORISPONDING CELL. SO FOR EXAMPLE-if a1>0 then 10, if b1>0 then 20, and if c1>0 then 30 = 60. G1 formula is displayed in the picture. as is the formulas for building whehter or not a1, b1, or c1, has values.
If you look at the above picture, wou will see three columns, colum a has the values to check for. Column b is the actual formulas that give the valuesYOU PROVIDED IF THERE IS A VALUE IN EACH CORISPONDING CELL. SO FOR EXAMPLE-if a1>0 then 10, if b1>0 then 20, and if c1>0 then 30 = 60. G1 formula is displayed in the picture. as is the formulas for building whehter or not a1, b1, or c1, has values.
alonsy
Posts
6
Registration date
Friday April 18, 2014
Status
Member
Last seen
April 21, 2014
Apr 21, 2014 at 07:48 PM
Apr 21, 2014 at 07:48 PM
Thank you! I got it figured out.
alonsy
Posts
6
Registration date
Friday April 18, 2014
Status
Member
Last seen
April 21, 2014
Apr 21, 2014 at 10:39 PM
Apr 21, 2014 at 10:39 PM
Sure, thanks again!
Apr 18, 2014 at 04:50 PM
Thanks.
Apr 18, 2014 at 05:47 PM
Apr 18, 2014 at 05:51 PM
=IF(logic_test,true,false)
You can also do something like:
=IF(logic_test,IF(LOGIC_TEST,true,false),false)
So what shouldl the output be if all of them have a number?
Would the output be 60?
Apr 18, 2014 at 08:42 PM
If only A1 has a value, then G1 should only read 10.
etc.