How to add this?

D

Danish Ayub

i want to add two cells ignoring & bypassing the percentage value cell which
comes in the middle.

100+10%+100

the result i want is 200.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF: How to add some cells and ignore other cells in a row 2
How do I express the following calculation. 3
creating a calculator 1
3 COLOR SCALE CONDITIONAL FORMATING WITH FORMULAS 3
If statement with multiple criteria and multiple results 3
Conditional format of range 3
Calculating Averages - Very Complex PLEASE HELP 7
Can I add to a cell value without manual calculation? 1

Top