| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formula
How do I formulate the following in Excel.
A1 A2 A3 45 55 {(45+55)}*30% = 30 I hope I made myself clear. What I want is formula in A3 which will directly give me 30%. TIA |
|
#2
|
|||
|
|||
|
One way:
= (A1 + A2) * 30% In article , "J.C.De" wrote: How do I formulate the following in Excel. A1 A2 A3 45 55 {(45+55)}*30% = 30 I hope I made myself clear. What I want is formula in A3 which will directly give me 30%. TIA |
|
#3
|
|||
|
|||
|
Thanx.
"JE McGimpsey" wrote in message ... One way: = (A1 + A2) * 30% In article , "J.C.De" wrote: How do I formulate the following in Excel. A1 A2 A3 45 55 {(45+55)}*30% = 30 I hope I made myself clear. What I want is formula in A3 which will directly give me 30%. TIA |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with a formula | Excel Discussion (Misc queries) | |||
| Cannot change a formula | Excel Discussion (Misc queries) | |||
| Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
| how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
| Creating Formula using check boxes | Excel Discussion (Misc queries) | |||
Linear Mode
