Formula/function shortcut?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I thought I read a question like this before, but I couldn't find it. So excuse me if I'm repeating a question. I'm using the formula, =CEILING((N194/J194)*65%+(N194/J194),0.05), what I would like to know is there a way to repeat (N194/J194) with out typing is over, in the same formula. Or is there a simpler way of doing it. This one isn't to long, but some of my if functions and get pretty long and you have a greater risk in a typo. Thanks! Pam
 
Hi Pam!

Pointing and clicking are better than typing in the cell references
manually.

During entry,

You can press F2 arrow back
use shift+arrow to select part of the formula,
copy
then arrow forwards
paste
Press F2 again and you're in direct entry mode again.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Pam said:
I thought I read a question like this before, but I couldn't find
Click to expand...
it. So excuse me if I'm repeating a question. I'm using the formula,
=CEILING((N194/J194)*65%+(N194/J194),0.05), what I would like to know
is there a way to repeat (N194/J194) with out typing is over, in the
same formula. Or is there a simpler way of doing it. This one isn't to
long, but some of my if functions and get pretty long and you have a
greater risk in a typo. Thanks! Pam
 
Pam,

highlight what you want to repeat in the formula, hold the ctrl + c, then
click where you want to repeat it, then hold ctrl + v.


Pam said:
I thought I read a question like this before, but I couldn't find it. So
Click to expand...
excuse me if I'm repeating a question. I'm using the formula,
=CEILING((N194/J194)*65%+(N194/J194),0.05), what I would like to know is
there a way to repeat (N194/J194) with out typing is over, in the same
formula. Or is there a simpler way of doing it. This one isn't to long, but
some of my if functions and get pretty long and you have a greater risk in a
typo. Thanks! Pam
 
Back
Top