Software

Ask something
Discussion Locked

Excel formulas without equal sign

0 helpful
6 replies

by drewbru

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I would like to find a way to enter a formula without using the equal sign.
Example: enter "100*1.2"
The markup changes for each line depending on the item. Our secretary can enter the numbers extremely fast but it slows her down to go over to the equal sign before each entry.
It would also slow her down to enter the amounts in different columns depending on the markup.
Does anybody have any ideas for this?
Your help is greatly appreciated.
Thanks
Drew

6 replies

by rob1150

I believe there is also a way to change the mapping of the keyboard. I am sorry that I dont know what that is, but I remember somewhere in the past being able to change what character the system would display when you hit certain keys. You could change the "/" key to enter a "=" sign and then she would not have to leave the number key pad. Just an idea.

by jackofalltech

No offence, but I don't think much of a secretary who is slowed down by moving his/her pinkie half an inch up from the home row. I would just tell him/her to practice more and get better.

Ralph

by malcolm r

before you criticize others. She's obviously entering the forumlas on the numeric keypad. It's a long way to the "=" key from there.

Malcolm

by ak47

Your secretary is probably using the numeric keypad and instead of using the "=" sign, she can use the "+" sign for entering formulas. I had continue using the "+" sign from the older Lotus 123 days.

by bobbarnes

This is the best solution, as Excel converts the + sign to an = sign when it recognizes that you are typing in a formula.

P.S. ignore the small minded people who post derogitory remarks... such consultants aren't exaxtly in high demand!

This discussion is closed to new replies.