Search results

TY! - I will check this

Thanks ! This looks perfect to me and I tried to utilize it but it is not calculating correctly. driving me nuts. for example - I have a column it is looking at that has 15 total bottles that fit the criteria for the second half, and 12 that are between a and 48, the calc shows 97% rather...

This almost works. But I am pretty sure I need the 1st line to be anything between 0 and 48, and the second one to be anything > 48. I can take care of the second one but how do i alter your first part of the formula to say >=0 to <=48?

Thanks - I will try this!

I have a table with columns where a value is either not completed yet based on another formula (shows as a negative value (-45644.0) or is a positive value (number of days since completed) in that column. I need a formula that looks at the positive values and compares it to a target (48 days...