| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
The goal is 5 per 100 transactions, how do I write formula for %
I'm new to Excel and I'm trying to write this formula; please help!
For example: 100 Transactions done today 5 subscriptions =100% andy |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
The goal is 5 per 100 transactions, how do I write formula for %
In A1 put 100
In A2 put 5 In A3 put =A2*20/A1 and format as percentage -- Gary's Student "andy3468" wrote: I'm new to Excel and I'm trying to write this formula; please help! For example: 100 Transactions done today 5 subscriptions =100% andy |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
The goal is 5 per 100 transactions, how do I write formula for %
With your Transactions in A1, and your Subscriptions in A2, Type this formula
in A3 =LOOKUP(A2/A1,{0,0.05,0.051},{"less than 100%","100%","Over 100%"}) hth Vaya con Dios, Chuck, CABGx3 "andy3468" wrote: I'm new to Excel and I'm trying to write this formula; please help! For example: 100 Transactions done today 5 subscriptions =100% andy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to write a formula for a price that is multiples for one amoun | Excel Discussion (Misc queries) | |||
| Help to write a formula using a letter value and a number value | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Write formula to add "1" to each number in a column | Excel Worksheet Functions | |||
| How can I write an if-then formula for 0 or less than 0 in cell t. | Excel Worksheet Functions | |||
Linear Mode
