ExcelBanter - How to add this?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to add this? (https://www.excelbanter.com/excel-discussion-misc-queries/210986-how-add.html)

Danish Ayub

How to add this?

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.

Mike

How to add this?

Cell A1=100
Cell B1=10%
Cell C1=100
Put this into Cell D1 =A1+C1

"Danish Ayub" wrote:

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.

All times are GMT +1. The time now is 10:33 AM.