what is the symbol used for division problems on an excel doc? how to
lay-out a division formula ...
what is the symbol used for division problems on an excel doc? how to
lay-out a division formula ...
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
[email protected]> wrote in message
news:[email protected]...
> what is the symbol used for division problems on an excel doc? how to
> lay-out a division formula ...
=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 ...
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
Double check and make sure that you used " / " and *not* " \ ".
--
HTH,
RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================
"rmartens" <[email protected]> wrote in
message news:[email protected]...
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks