| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
writing formulas in VB - referring to the values contained in cell
I'm new to writing code from scratch and I'm struggling with something.
Basically I have a row of numbers and beneath it I need a row which is the % value that the number above is of the leftmost number. ie: 50 42 8 84 16 The row is a different number on every sheet so I can't use specific cell references. I've managed to name all the cells that's not the problem, but I'm unsure of the syntax for the mathmatical formula. per1 = (p2 / (p1 / 100)) where p2 and p1 are names of cells, and per1 is a string isn't working. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a list of formulas contained in a Workbook | Excel Discussion (Misc queries) | |||
| Referring to sheets in formulas | Excel Discussion (Misc queries) | |||
| Sum values referring to a cell with same value | Excel Discussion (Misc queries) | |||
| how can I imbed sheet names contained in cells into formulas? | Excel Worksheet Functions | |||
| referring to other cells with formulas | Excel Worksheet Functions | |||
Threaded Mode
