Related:
- Add value to one cell if multiple other cells have any value
- If cell contains text then add text to another cell ✓ - Forum - Excel
- Excel add rows based on cell value - Forum - Excel
- Search for a Keyword. Add Value from another cell. ✓ - Forum - Excel
- 40 % add formula in excel cell ✓ - Forum - Excel
- If multiple cells contain value then add value ✓ - Forum - Excel
2 replies
- Posts
- 10939
- Registration date
- Monday June 3, 2013
- Status
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.
- Posts
- 6
- Registration date
- Friday April 18, 2014
- Last seen
- April 21, 2014
-Thanks.
=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?
- Posts
- 6
- Registration date
- Friday April 18, 2014
- Last seen
- April 21, 2014
-If only A1 has a value, then G1 should only read 10.
etc.