Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 19
Default Subtraction

I have been trying to subtract 2 simple numbers. I can do it by entering the
formula =123-111 but would to make a formula where I could use the cell as a
reference (ie H2-H3)

I have also been trying to find the average of 2 numbers. I use
=AVERAGE(H2,H3)
I get #DIV/0! I can't seem to get it to divide by 2.
 
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
Subtraction Chart Bunnie Excel Discussion (Misc queries) 8 December 14th 06 02:06 AM
Cell subtraction gudway New Users to Excel 3 May 4th 06 01:31 PM
subtraction formula kaustubhghag Excel Worksheet Functions 1 March 24th 06 12:14 PM
subtraction formula Mart Excel Worksheet Functions 1 February 23rd 06 11:47 AM
Subtraction formula Al Excel Discussion (Misc queries) 6 December 21st 05 08:46 AM


All times are GMT +1. The time now is 06:20 PM.

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"