ExcelBanter - formula

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

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - formula (https://www.excelbanter.com/new-users-excel/176221-formula.html)

ramaeng

formula

Can anyone tell what is the formula for add 1+090 plus 2+090 (please)

Mike H

formula

Hi,

Surprisingly it's

=1+90
=2+90
or to add the lot

=1+90+2+90

Mike

"ramaeng" wrote:

Can anyone tell what is the formula for add 1+090 plus 2+090 (please)

Gord Dibben

formula

090 is not a number so you cannot add anything to it.

If 090 is actually 90 with a custom format of 000 then

=1+90+2+90 would be 183

Gord Dibben MS Excel MVP

On Sun, 10 Feb 2008 05:39:01 -0800, ramaeng
wrote:

Can anyone tell what is the formula for add 1+090 plus 2+090 (please)

All times are GMT +1. The time now is 12:36 PM.