Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Greetings,
I have searched the Forum and have not found the answer. If you know the link post it and I will look there. I want to take the number 500 in one column and & place a Percentage like 10% in the next column and it add the two columns with a result of 550 in the third column. This is the only function I need, I don't need a total at the end of the page or anything like that. Thanks for the help |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Allen
=(A1*B1)+A1 -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Allen" wrote in message ... Greetings, I have searched the Forum and have not found the answer. If you know the link post it and I will look there. I want to take the number 500 in one column and & place a Percentage like 10% in the next column and it add the two columns with a result of 550 in the third column. This is the only function I need, I don't need a total at the end of the page or anything like that. Thanks for the help |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Allen, here is one way, with 500 in A1 format cell B1 as percent then put in
10 in C1 put =A1*B1+A1 -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Allen" wrote in message ... Greetings, I have searched the Forum and have not found the answer. If you know the link post it and I will look there. I want to take the number 500 in one column and & place a Percentage like 10% in the next column and it add the two columns with a result of 550 in the third column. This is the only function I need, I don't need a total at the end of the page or anything like that. Thanks for the help |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() -- Taglia "Allen" wrote: Greetings, I have searched the Forum and have not found the answer. If you know the link post it and I will look there. I want to take the number 500 in one column and & place a Percentage like 10% in the next column and it add the two columns with a result of 550 in the third column. This is the only function I need, I don't need a total at the end of the page or anything like that. Thanks for the help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
number format | Excel Discussion (Misc queries) | |||
vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
Preceding a number by zeros, that is still a number | Excel Worksheet Functions | |||
Number of labels on X-axis one more than number of values on Y-axi | Charts and Charting in Excel | |||
Percentage of a number | Excel Discussion (Misc queries) |