Formula for Greater Than Statements

[busby22]

I have a column that I need to figure a formula for and need HELP.... I'll try to explain...

Column A has a value of 62; in Column B, I want it to calculate the following: If Column A is greater than 60 take the remainder amount (which would be 2) and add 4.5 then multiply that number by 12.

I'm sure this is a pretty easy formula, i just don't know how to write it so it just uses the amount greater than 60???

[Pete_UK]

MOD(A1,60)

will give you the remainder after dividing by 60, but you don't say what you want to happen if column A is not greater than 60.

Pete

[nitin.asalkar]

Try this
=IF(A1>60,(MOD(A1,60)+4.5)*12,"")

[busby22]

Genius!!! It works; Thanks for your help!!!

[busby22]

Just out of curiousity, what is the MOD function doing in the equation?

[Pete_UK]

See post #2

Pete