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: 1
Default creating formula for subtraction and then division

i have my number in E11 and E10 like this

E11 "884.90"
E10 "868.05"

i want my ans as E11-E10/E10 like this (868.05-884.90)/868.05
how to create formula for this?

i want to use this function for the whole sheet..so how do i do it?
--
plz help
-hetal
 
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
HOW DO I CREATE A SUBTRACTION FORMULA MEDIC70736 Excel Worksheet Functions 2 January 18th 07 04:06 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
how do i do a subtraction formula jules Excel Worksheet Functions 3 December 30th 04 03:43 AM


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