IF Function help

[jond291]

I really need help with an IF function I'm trying to create, I need it to go like this:

If cell O10 is greater than 37.5, then select the value in cell O12, If not display a zero.

I feel like I'm missing something very simple, but I just can't figure it out.

Apologies if this has been asked before, I've tried finding an answer myself but wasn't sure how to word the question and couldn't find anything.

Thanks for any help!

[wenqq3]

Please Login or Register  to view this content.

[dilipandey]

Hi Jond291,

Use

Please Login or Register  to view this content.

and In which cell you need this result?

Regards,
DILIPandey
<click on below * if this helps>

[jond291]

Both answers work great, thanks a lot for your help

[dilipandey]

There is a little difference in both the answers
"0" will give you Zero as text
and
0 will give you zero as number

- choose whatever you need.


Regards,
DILIPandey
<click on below * if this helps>