Question about Microsoft Computers & Internet
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
×
Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!
Posted on Jan 02, 2017
Mar 04, 2017 | Formula Computers & Internet
Apr 02, 2008 | Computers & Internet
Mar 06, 2015 | Microsoft Excel 2010
Sep 16, 2014 | Microsoft 1994 Office Excel Spreadsheet...
Apr 09, 2014 | Microsoft Excel for PC
Jan 02, 2014 | Soda iSpreadsheet
Sep 24, 2009 | Microsoft Excel for PC
Apr 10, 2009 | Microsoft Excel for PC
Sep 30, 2008 | Microsoft Excel for PC
Aug 08, 2008 | Microsoft Excel for PC
May 31, 2017 | Microsoft Computers & Internet
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
×