LinkBack URL
About LinkBacks
I'm needing help with an IF formula:
If B37 is >=0 and <=45 then it equals cell B101.
I can post a coy of spreadsheet if needed.
Thanks in advance!
I'm needing help with an IF formula:
If B37 is >=0 and <=45 then it equals cell B101.
I can post a coy of spreadsheet if needed.
Thanks in advance!
How about:
Cheers,
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.
This works for the true statement of equaling B101. However, the false statement isn't working. I still get the result of cell B101 if the statment is false.
Any ideas on how to correct?
What value are you testing the false statement with?
Put a 50 in cell B37, and a 0 will return
It is saying if B37 = More than 0 but less than 45, then B101, otherwise 0. So a 46 or more returns a 0, and a -1 or less returns a 0
You should hit F5, because chances are I've edited this post at least 5 times.
Example of Array Formulas
Click the * below on any post that helped you.Originally Posted by Jacc
It does work theoretically but my formula doesn't appear to work correctly. I'm attaching a sample of the spreadsheet to show exactly what I have and how the false statement doesn't populate.
It's based on Date/Time In and Task Performed Date/Time.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks