Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
To find equation for two sets of non contiguous data | Charts and Charting in Excel | |||
Equation Editor- problem when editing an equation | Excel Discussion (Misc queries) | |||
Need Help with #N/A in equation | Excel Discussion (Misc queries) | |||
Averaging/Rounding Equation problem | Excel Discussion (Misc queries) | |||
Logarithmic Trendline Equation | Charts and Charting in Excel |