LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 7
Default excel formulae

problem with entering new formulae. I want to sum cells w45 and x44, and
subtract cell x45. When I enter it the formulae looks right but the value
comes up as 0 whenit is not.
on another worksheet, this works. On this new one it doesnt, so its like a
format thing or whatever. I haev tried =sum(w45+x44-x45) also = w45+x44-x45,
and other ways - no luck.
 
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
using formulae in excel conroy Excel Worksheet Functions 4 January 10th 07 08:04 PM
Lost Excel formulae XL? New Users to Excel 1 February 9th 06 11:10 AM
excel formulae zemarko Excel Discussion (Misc queries) 1 August 3rd 05 05:41 PM
Searching TEXT in formulae, rather than results of formulae AndyE Excel Worksheet Functions 1 July 15th 05 10:57 AM
Excel and CubeCell Formulae les Excel Discussion (Misc queries) 0 March 9th 05 11:28 AM


All times are GMT +1. The time now is 12:54 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"