LinkBack URL
About LinkBacks
Hello,
Please see the attached word doc. to this post for a screenshot explaining my problem. I would appreciate any help. Thanks!
Hello,
Please see the attached word doc. to this post for a screenshot explaining my problem. I would appreciate any help. Thanks!
You know how to attach word file, so attach excel file , not a picture in word doc.
Also, please explain the nature of the problem within the thread itself so that members do not have to open attachments.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
I have a range of cells whereby I wish to select the only positive value (all other cells within this range will always equal zero) to automatically put forward for use into an equation. Can I do this with the IF function? This is difficult to explain as I have very little Excel knowledge.
Please find excel spreadsheet attached; this will demonstrate more clearly what I'm looking to do. Refer to Sheet 2 where you will find 'XLT' and the range of cells aforementioned.
no excel file attached
File attached here.
could you tell me when this formula will be negative?
=(2.8/86.8)*SQRT((Sheet1!K21*Sheet1!K20)/(1.5*Sheet1!K22^2))
btw. dimensions cannot be negative. In drastic case it can be 0
and where is the result formula which uses the indicated range ?
Last edited by sandy666; 07-26-2017 at 06:03 AM.
Hi,
To return the only non-zero value from the range D43:H51, you might use MAX(D43:H51)
Don
Please remember to mark your thread 'Solved' when appropriate.
Thanks for the replies.Originally Posted by sandy666
I've only just typed out that equation / result formula as I didn't know how to incorporate the indicated range. However, after using @xlnitwit's input it has worked.
That formula cannot give a negative answer (i.e. the formula gives a shear / bending resistance which in this case cannot be negative). Dimensions cannot be negative? Thanks for the heads up. Fortunately I don't think I will have any of those.
for the future: The number 0 is the smallest non-negative integer so better to use in description: positive non-zero values
Last edited by sandy666; 07-26-2017 at 07:41 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks