Greater than formula
I am sure this is very simple but I cannot get what I need in a formula so I
am hoping someone can help me. I need a formula to let me know exactly how many days I have over a set amount, for instance. Column A I have Minimum days of 3 Column B I have Daily volume of 350 Column C I have Days on hand of 6.9 Column D I have total pieces on hand of 2420 Column E I have box quantity of 1210 Column F I have minimum box required 0.9 Column G I have counted exactly 2 boxes Column H I have Max Days allowed is 3.5 Now I need to have a formula in Column I stating how many days I have went over my max days allowed of 3.5, can someone please provide a formula? Thank you in advance, |
Greater than formula
if i read you right this will work, it takes anything over 3.5 days (3.5*350)
and tells you over =IF(B1350*3.5,"Over","") -- -John Northwest11 Please rate when your question is answered to help us and others know what is helpful. "Angela" wrote: I am sure this is very simple but I cannot get what I need in a formula so I am hoping someone can help me. I need a formula to let me know exactly how many days I have over a set amount, for instance. Column A I have Minimum days of 3 Column B I have Daily volume of 350 Column C I have Days on hand of 6.9 Column D I have total pieces on hand of 2420 Column E I have box quantity of 1210 Column F I have minimum box required 0.9 Column G I have counted exactly 2 boxes Column H I have Max Days allowed is 3.5 Now I need to have a formula in Column I stating how many days I have went over my max days allowed of 3.5, can someone please provide a formula? Thank you in advance, |
Greater than formula
John...this worked great.
Thank you so much. Angela "John Bundy" wrote: if i read you right this will work, it takes anything over 3.5 days (3.5*350) and tells you over =IF(B1350*3.5,"Over","") -- -John Northwest11 Please rate when your question is answered to help us and others know what is helpful. "Angela" wrote: I am sure this is very simple but I cannot get what I need in a formula so I am hoping someone can help me. I need a formula to let me know exactly how many days I have over a set amount, for instance. Column A I have Minimum days of 3 Column B I have Daily volume of 350 Column C I have Days on hand of 6.9 Column D I have total pieces on hand of 2420 Column E I have box quantity of 1210 Column F I have minimum box required 0.9 Column G I have counted exactly 2 boxes Column H I have Max Days allowed is 3.5 Now I need to have a formula in Column I stating how many days I have went over my max days allowed of 3.5, can someone please provide a formula? Thank you in advance, |
All times are GMT +1. The time now is 03:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com