Excel If Functions

Copper Contributor

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.

 

1 Reply

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