Question about Microsoft Business & Productivity Software
Hi, I have a spreadsheet as follows
Column A
1
17
23
34
54
67
18
23
15
3
I would like a formula which identifies all cells either singly or together with a another cell which add up to say 18.
Thanks
Ronnie
Hi
yes it can be done using if function.
example of how to use if function,
IF(A1=B1,C1,D1)
this wl print the value at C1 if value at A1 and B1 is equal else it wl print value at D1
You can try with this.
I too wl be trying and now for exact solution.
Goodluck
Posted on Sep 09, 2008
I get your point. But thinking of it is kinda complicated. The formula I believe is a combination of Nesting IF and VLookup but its hard to do it. Better consult some excel pro or accountant to simplify what you want.
Posted on Sep 09, 2008
Haven't used excel in a while. I would use the IF function to tell me if this and this adds up to 280
http://www.timeatlas.com/mos/5_Minute_Tips/General/Excel_Basics_and_the_IF_Function/
Posted on Sep 09, 2008
What do you want to add up to 18? once I understand exactly what your trying to do I will be able to assist you further.
Thanks,
Lee
Posted on Sep 09, 2008
http://www.timeatlas.com/mos/5_Minute_Ti...
http://www.functionx.com/excel/Lesson14....
Its not very difficult just very hard to just explain. It has already been done in the lessons. You need to use the IF and vlookup function and that should do it. the second link has basically everything you could ever need to know. I hope you will reconsider the rating as you should have found this information at least helpful.
Thanks,
Lee
×
Mar 06, 2015 | Microsoft Excel 2010
Apr 02, 2008 | Business & Productivity Software
Sep 16, 2014 | Microsoft Excel for PC
Apr 09, 2014 | Microsoft Excel for PC
Sep 24, 2009 | Microsoft Excel for PC
Aug 26, 2009 | Microsoft Office Excel 2007
Apr 10, 2009 | Microsoft Excel for PC
Feb 25, 2009 | Business & Productivity Software
Sep 30, 2008 | Microsoft Excel for PC
Aug 08, 2008 | Microsoft Excel for PC
96 people viewed this question
Usually answered in minutes!
Hi, Ok I will try to simplify it here.
Row Column A Column B
1 Type of Fruit
2
3
4
5
6
Hi, Ok I will try and simplify it here
Row Column A Column B
1 Product Qnty
2 Disks 285
3 Scanners 256
4 MO Disk 24
5 Plasma 2,125
6 Ext Storage 280
7 laptop A 200
8 Laptop B 80
Problem: I need excel to tell me which cell or cells from B2 to B8 add up to the number 280.
From a visual inspection I would say B3&B4, B6 and B7&B8. But I would like Excel to do this for me automatically.
Thanks
Ronnie999
Hi, Ok I will try and simplify it here
Row Column A Column B
1 Product Qnty
2 Disks 285
3 Scanners 256
4 MO Disk 24
5 Plasma 2,125
6 Ext Storage 280
7 laptop A 200
8 Laptop B 80
Problem: I need excel to tell me which cell or cells from B2 to B8 add up to the number 280.
From a visual inspection I would say B3&B4, B6 and B7&B8. But I would like Excel to do this for me automatically.
Thanks
Ronnie999
Hi, Would really really require some help on this. Thanks
×