Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() 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
|
|||
|
|||
![]()
"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
|
|||
|
|||
![]() 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
|
|||
|
|||
![]() =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
|
|||
|
|||
![]()
=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
|
|||
|
|||
![]() 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 | |
|
|
![]() |
||||
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) |