| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mixed variable problem
Hello,
I have a WS that looks like this A B C 1 Net Sales: 1,411,676 Cost % 2 Salaries: 52,800 3.74% Basically C2 is equal to what percentage B2 is of B1. B2= B1 * C2 C2= B2 / B1 I need to design a worksheet where you can change eitehr the cost(B1) or the percentage(C1). Is there a way to do this with a logic statement somehow? I would appreciat any suggestions. Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| legend problem in mixed line-scatter graph Excel 2007 | Charts and Charting in Excel | |||
| Multiple Variable Count problem | Excel Worksheet Functions | |||
| Silly Problem with Variable (2nd attempt) | Excel Discussion (Misc queries) | |||
| Problem trying to us a range variable as an array variable | Excel Programming | |||
| Problem with copying variable(s) to cell(s) and converting strings to mixed case | Excel Programming | |||
Threaded Mode
