LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ted
 
Posts: n/a
Default Ok, here is the Correct equation I am having trouble with€¦ (from T

I have two main steps that I am trying to make in to one, which a

=ROUND(7/(A5-B5),5)
here I want it to take divide 7 A5-B5 rounded to 5 decimal places

=IF(A50.5,A5,"")
here I want it to remove any answers from the above that equal 0.5 or less
because its outside of the range I am looking at. Thats why I have added the
A5,€€ part €“ so to replace the answer with a blank(?)


I have tried many different combinations to get these two to add together,
so I can run it al in one cell, rather than two sets as I currently have.

Is this possible, and if so, how please??


Thanks for all earlier responses, and I am sorry for the poor equations I
entered earlier, that didnt even make sense because I wrote them wrong €“ not
a good start!

Ted.

 
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
To find equation for two sets of non contiguous data vijaya Charts and Charting in Excel 2 November 7th 05 03:46 AM
Equation Editor- problem when editing an equation Gaby L. Excel Discussion (Misc queries) 0 September 27th 05 09:24 PM
Need Help with #N/A in equation mkerstei Excel Discussion (Misc queries) 7 July 29th 05 09:03 PM
Averaging/Rounding Equation problem Hansel Excel Discussion (Misc queries) 4 June 28th 05 08:45 PM
Logarithmic Trendline Equation Phil Hageman Charts and Charting in Excel 2 January 13th 05 11:55 AM


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