One cell calculation
Solved/Closed
Alex
-
Jan 27, 2010 at 03:12 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 13, 2010 at 09:18 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 13, 2010 at 09:18 PM
Related:
- One cell calculation
- Calculation is incomplete. recalculate before saving - Guide
- Free electrical load calculation software - Download - Calculators
- If cell contains date then return value ✓ - Office Software Forum
- Conditional formatting if cell contains text - Excel Forum
- Excel formula to subtract one cell from another - Excel Forum
6 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jan 27, 2010 at 09:09 PM
Jan 27, 2010 at 09:09 PM
As long as there are 3 numbers and configsuration same
first number comma space second number comma space thrid number
then the following macro will get you the result in B1
A formula can be built up but for me it will be complicated.
the macro is
first number comma space second number comma space thrid number
then the following macro will get you the result in B1
A formula can be built up but for me it will be complicated.
the macro is
Sub test()
Dim j, j1, k, k1, m, m1, n
j = InStr(Range("a1").Value, ",")
j1 = Left(Range("A1").Value, j - 1)
k = InStr(j + 1, Range("A1").Value, ",")
k1 = Mid(Range("A1").Value, j + 2, k - 4)
m1 = Right(Range("A1").Value, Len(Range("A1").Value) - k)
n = WorksheetFunction.Sum(j1, k1, m1)
'MsgBox n
Range("B1") = n
End Sub
Game Start Now
Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
7
Jan 28, 2010 at 11:57 PM
Jan 28, 2010 at 11:57 PM
i paste this code in macro but what i type in excel to get the result ?
like =subtest(A1) or something else
like =subtest(A1) or something else
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jan 29, 2010 at 05:15 AM
Jan 29, 2010 at 05:15 AM
open vb editor (control+F11)
hit control+R
the project window opens on the left side
all the open workbooks names will be there.
highlight this present workbook
click insert(menu bar in vb editor) and cllic module
in the module that coems up copy paste the macro
remember the name of the macro is "test"
save the file
go the sheet
clcik tools(menubar of the sheet)-macro-macaro
you get the list of macros of all open workbook
highlgith the "test" in the list
and click RUN on the right side
now see B1 of the sheet.
I might have missed some steps like Ok . you take cares of these if necessary.
later you can change the name of the macro as you wish.
if any more doubts revert back to newsgruop
hit control+R
the project window opens on the left side
all the open workbooks names will be there.
highlight this present workbook
click insert(menu bar in vb editor) and cllic module
in the module that coems up copy paste the macro
remember the name of the macro is "test"
save the file
go the sheet
clcik tools(menubar of the sheet)-macro-macaro
you get the list of macros of all open workbook
highlgith the "test" in the list
and click RUN on the right side
now see B1 of the sheet.
I might have missed some steps like Ok . you take cares of these if necessary.
later you can change the name of the macro as you wish.
if any more doubts revert back to newsgruop
Didn't find the answer you are looking for?
Ask a question
if i have 600.00 in cell b and want the formular for the percentage of that sum in cell d how do i do that
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Nov 13, 2010 at 09:18 PM
Nov 13, 2010 at 09:18 PM
thre is not cell b but cell b1 , b2 etc simiarly for d or any other column
suppose b1 has entry 1
d1 has entry 2
in empty cell type
=b1/d1
for mat this cell as perecentage.
suppose b1 has entry 1
d1 has entry 2
in empty cell type
=b1/d1
for mat this cell as perecentage.
