"If" Function to return value greater than...

[Debbe]

Greetings, hope I'm posting in the write forum.

I need a formula/function to do the following:

Cell A1 = 8
Cell B1 returns any value greater than 8, for example: A1 = 10, then cell B1 = 2
If cell A1 is less than 8 than cell B1 returns 0.

Thank you for your help,
Debbe

[zbor]

Maybe =MAX(0, A1-8)

[jwright650]

Please Login or Register  to view this content.

[Debbe]

Thank you John, that did the trick.

[Debbe]

Sorry Zbor, you were actually right. Your formula works perfect. Thanks!