If statement using whole number as criteria for true

[Mldeuser]

I am trying to write an IF statement that would look at cell H16 and if it is a whole number than it would multiply C16*H16 otherwise move on the then next IF statement.

Any help would be greatly appreciated

Thank you

 

[JoeMo]

=IF(INT(H16)=H16,C16*H16, rest of if statement ...)

 

[T. Valko]

I am trying to write an IF statement that would look at cell H16 and if it is a whole number than it would multiply C16*H16 otherwise move on the then next IF statement.

Any help would be greatly appreciated

Thank you

Assuming that H16 will only contain numeric data...

Soemthing like this:

=IF(INT(H16)=H16,C16*H16,...

 

[Mldeuser]

Thank you both for the help, it worked.

 

[T. Valko]

Thank you both for the help, it worked.

You're welcome. Thanks for the feedback!