| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Percentage calculation
In G18, I want this cell to calculate 10% of the number in H17. How can I make a formula for this? I try to simply put in =H17(0.1), but it gives me a !REF error. Thanks. -- Roz ------------------------------------------------------------------------ Roz's Profile: http://www.excelforum.com/member.php...o&userid=29746 View this thread: http://www.excelforum.com/showthread...hreadid=498761 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Percentage calculation
"Roz" wrote in message
... In G18, I want this cell to calculate 10% of the number in H17. How can I make a formula for this? I try to simply put in =H17(0.1), but it gives me a !REF error. Thanks. =H17*0.1 or =H17/10 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Percentage calculation
Roz Wrote: In G18, I want this cell to calculate 10% of the number in H17. How can I make a formula for this? I try to simply put in =H17(0.1), but it gives me a !REF error. Thanks. *=0.1*H17* is your formula. Regards. -- BenjieLop ------------------------------------------------------------------------ BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019 View this thread: http://www.excelforum.com/showthread...hreadid=498761 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Percentage calculation
=h17*.1
"Roz" wrote: In G18, I want this cell to calculate 10% of the number in H17. How can I make a formula for this? I try to simply put in =H17(0.1), but it gives me a !REF error. Thanks. -- Roz ------------------------------------------------------------------------ Roz's Profile: http://www.excelforum.com/member.php...o&userid=29746 View this thread: http://www.excelforum.com/showthread...hreadid=498761 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Percentage calculation
Thanks to all you geniuses! -- Roz ------------------------------------------------------------------------ Roz's Profile: http://www.excelforum.com/member.php...o&userid=29746 View this thread: http://www.excelforum.com/showthread...hreadid=498761 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Percentage calculation
=H17*10% Regards JG -- pinmaster ------------------------------------------------------------------------ pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261 View this thread: http://www.excelforum.com/showthread...hreadid=498761 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Percentage Increase Calculation | Excel Discussion (Misc queries) | |||
| Percentage calculation on text columns | Excel Discussion (Misc queries) | |||
| Percentage Calculation | Excel Worksheet Functions | |||
| Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
| Percentage calculation error | Excel Discussion (Misc queries) | |||
Hybrid Mode
