[ms office - o365] Excel formula

[LTurner3692]

Hello All,

 

Im trying to get a formula to do as i want but being stupid i cant work it out!

 

The formula is =IF((AND(A15>=60,A15<=60)),0,(A15-60*C15))

 

So what im after is if A15 is 60 or below then nothing happens but if its above 60 i want to take 60 off and multiply!

 

Where am i going wrong?

[Mako]

If I'm understanding your request properly:

 

=IF(A1<=60,"-",(A1-60)*A2)

 

If A1 is less than or equal to 60, then nothing. Unfortunately you can't have a "do nothing", so I've replaced the value with a dash.

 

Otherwise you take A1 and subtract 60, then multiply the result by whatever cell you want.

[LTurner3692]

Thats the ticket! i knew it was easier than i was making it out to be!

[SeanAllen]

You can use empty quotes "" that'll leave the cell empty.