#1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default formula

Can anyone tell what is the formula for add 1+090 plus 2+090 (please)
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 11,501
Default 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)

  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 22,906
Default 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)


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 08:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"