LinkBack URL
About LinkBacks
How do I syntax this?
=IF(E2>0,E2,0)
Buzz
How do I syntax this?
=IF(E2>0,E2,0)
Buzz
Try this:
Please Login or Register to view this content.
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
Hi,
Can you be more precise with your title. Zero meets both conditions.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
I read that as zero meeting neither of the conditions...
If I've been of help, please hit the star
If the value of the cel is greater than "0" i want to return the value of the cell.Originally Posted by Richard Buttrey
If it is less than "0" I just want zero (or blank)
buzz, welcome to the forum.
What if the value of the cell is 0? That possibility is not covered in your elaboration (post # 5)
Brendan.
__________________________________________________________________________________________________
Things to consider:
1) You can thank any poster by clicking the * at the left of a helpful post.
2) You can help to keep the forum tidy by marking your thread as "Solved", if it has been answered to your satisfaction.
3) Help us to help you, by uploading a sample workbook, showing the type of data you're dealing with, and clearly indicating what the results should be.
=IF(E2>0,E2,0) doesnt that work as it is?
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
That worked great but I have to use a hidden cell.
How can I combine into one formula?
D2 = start time (10:30 AM)
C2 = stop time (3:30 PM)
E2=(D2-C2)*24
=MAX(E2,0)
I'm confused Buzz....if I put data in column A that has positve and negative numbers and some zeros. And then in column B use either your formula (changing the E to an A) or using ConneXionLost MAX formula, I get the results that you are requesting in your last post...
Ernest
Yea it wrks but now I'm trying to use that fromula with the result of this formula.
I can accomplish in 2 cells but I'm sure there's a way to write it together.
=(D2-C2)*24
=IF(E2>0,E2,0)
no help judge?
max((D2-C2)*24,0) surely?
Thanks, I'm horribly out of practice with this stuff.
Sorry Buzz....it was passed the end of my day....looks like Mr. Wilson did a great job....
Ernest
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks