Excel formula help

[sanrio melody]

Hi.

I would like to create a formula for the following. Hope you could help me. 

If A1 is equals to 38, D1 will have the value of 10.

But if A1 is not equals to 38, D1 will have the formula of B1/60. (B1 divided 60).

Thank you!

[#2 · Accepted solution]

Hi Sanrio,

You can translate this:

"If A1 is equals to 38, D1 will have the value of 10.

 But if A1 is not equals to 38, D1 will have the formula of B1/60. (B1 divided 60)."

To this in cell D1:

=IF(A1=38, 10, B1/60)

Very simple!

I hope this helps you

Haytham

[#3]

Hi Haytham,

Thank you very much for your help!