Oct 24 2018 06:49 PM - edited Oct 24 2018 06:55 PM
How can I use an if statement to calculate the number of hours needed in order to meet a requirement of 6? and I'm looking for if the number is less than 6, calculate how much it needs to be 6.
Oct 25 2018 05:15 AM
Hello Radhi,
there are a few possible layouts for your question, so I will take a guess.
If you have the hours in cell A1 in decimal format you could have a formula like
IF(A1>6;"requirements met";"Missing " & 6-A1 & "hours")
in another cell.
Please check if this helps you, if not please give more specific details.
Jens