Click here to Skip to main content
15,922,427 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more: (untagged)
like :- A B C
1
2
3
insted of aa bb cc
Posted

1 solution

Hello,

You can edit formulas as you would edit any other data. Select the cell, click the formula bar, edit the formula, and then enter the edited formula. Using the Edit Formula button:

Select the cell containing the formula you want to edit.
Click the Edit Formula button on the Formula Bar (more options like SumIF,Count,etc.. can be done easily using this)
Edit the formula.
Press Enter or click OK.
You dont need coding knowledge for this just knowledge about Common Arithmetic Operators

Operator:

Description: Example:
+

To add numbers =A+B
-

To subtract numbers =A-B
*

To multiply numbers =A*B
/

To divide numbers =A/B
%

To specify percentage of a number =50%
^

To specify the exponent =1^2


All the Best:)Write back if you need any more help
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900