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*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 |
#5
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 |
#6
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 |
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) |