David McRitchie

You are right.....it is amazing what some people teach and how some learn.
I need to remember that not everyone learned the way I did. As if my way is
the right way <g. Thanks David

Mike Rogers

"David McRitchie" wrote:

Good catch and if "jbclem" is entering formulas
without the "=" by turning transition formula
entry on, there is sure are going to be in trouble with Excel.
But I imagine there are some who do that and teach others
to do that. ~ is a tildea (has a Shift), ` is accent grave

"Mike Rogers" ...
The "ctrl ~" alllows you to toggle between the value derived from a formula
and the formula itself. But the formula will show in the cell and not calc
if the cell is formated as "Text" before the formula is entered or it does
not have the "=" sign to tell excel that you want it to be a formula. Check
the basics first and don't "over think" the problem!

"jbclem" wrote
I'm using Excel 2002 for the first time and trying to place a function into a cell.
I 'm using IF(N44=L, M44-L44, L44-M44) .
Which is supposed to mean If the letter L is in cell N44, then subtract
number in L44 from number in M44. Otherwise subtract M44 from L44.

If have 2 main questions...First, how to get the result of the function to show.
Right now I see the function typed out in the cell, but no result.