ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   symbol for divison problems; divison formula (https://www.excelbanter.com/excel-discussion-misc-queries/30221-symbol-divison-problems%3B-divison-formula.html)

excel general question ... help please

symbol for divison problems; divison formula
 
what is the symbol used for division problems on an excel doc? how to
lay-out a division formula ...

Andy Wiggins

Look up "About calculation operators" in the Excel help file.

(Help file extract)

Arithmetic operator Meaning (Example)
+ (plus sign) Addition (3+3)
- (minus sign) Subtraction (3-1)
Negation (-1)
* (asterisk) Multiplication (3*3)
/ (forward slash) Division (3/3)
% (percent sign) Percent (20%)
^ (caret) Exponentiation (3^2)


--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"excel general question ... help please" <excel general question ... help
wrote in message
...
what is the symbol used for division problems on an excel doc? how to
lay-out a division formula ...




Jonathan Cooper

=5/1

"excel general question ... help please" wrote:

what is the symbol used for division problems on an excel doc? how to
lay-out a division formula ...


rmartens

symbol for divison problems; divison formula
 

When I enter the example =5/1 I get an error message - The formula you
typed contains an error. Why doesn't excel recognize the / ???

Ron


--
rmartens
------------------------------------------------------------------------
rmartens's Profile: http://www.excelforum.com/member.php...o&userid=35583
View this thread: http://www.excelforum.com/showthread...hreadid=378186


RagDyeR

symbol for divison problems; divison formula
 
Double check and make sure that you used " / " and *not* " \ ".
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"rmartens" wrote in
message ...

When I enter the example =5/1 I get an error message - The formula you
typed contains an error. Why doesn't excel recognize the / ???

Ron


--
rmartens
------------------------------------------------------------------------
rmartens's Profile:
http://www.excelforum.com/member.php...o&userid=35583
View this thread: http://www.excelforum.com/showthread...hreadid=378186




All times are GMT +1. The time now is 03:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com