Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula for changing a percentage
In cell A2 is .0400
Cell B1 has a number of 20.33 Cell B1 and B2 (a formula also) are added together......to be multiplied by amt in Cell A2 Cell B5 is fixed at 21.52 Cell B4 adds B1, B2, B3 Can you tell a Cell that if B4 exceeds B5, change A2 to the proper % to reflect in Cell B3 when added with B1 and B2 it will not exceed B5. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula for changing a percentage
Hi,
You could use 'Goal seek' Select B4 then Tools|Goal Seek in the 'To Value' box enter the value in B5 in the 'By changing cell' box enter A2 Click OK Mike "Kim" wrote: In cell A2 is .0400 Cell B1 has a number of 20.33 Cell B1 and B2 (a formula also) are added together......to be multiplied by amt in Cell A2 Cell B5 is fixed at 21.52 Cell B4 adds B1, B2, B3 Can you tell a Cell that if B4 exceeds B5, change A2 to the proper % to reflect in Cell B3 when added with B1 and B2 it will not exceed B5. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing multiple cells by the same percentage | New Users to Excel | |||
Changing Font color automatically when Cell Format is Percentage | Excel Worksheet Functions | |||
Percentage Formula | Excel Discussion (Misc queries) | |||
IF formula & Percentage | Excel Discussion (Misc queries) | |||
changing the value of each cell in a range by a certain percentage | Excel Discussion (Misc queries) |