First, let me say y'all are the best!! You have helped me out time and time again...thank you!!
I have attached a sample spreadsheet for your review.
I think I need to combine multiple IF statements into one single statement. See column I:
There is currently a formula in Column I that looks at Column H and computes a ROUND formula based on this information. Unfortunately, this formula only works if Column J says "MB". If Column J says "Minutes" then I need Column I to compute with this formula:
=IF(H2<30,0.5,ROUNDUP(H2/60,1))
How can I combine this with the current formula to get what I am looking for? Here is the current formula (for MB):
=IF(H2<0.125,0.125,ROUND(H2,4))
Thanks in advance!
Carlyn
Bookmarks