add Round up to exiting IF,

[pmw19800]

Hello

Can a round factor be added to this formula?
=IF(J6>$H6,O6/20,C6/20)

I’m currently using a separate formula to round , (primitive way)
Please see attached for understanding.

Paul

[AliGW]

Didn't you try this?

=ROUND(IF(J6>$H6,O6/20,C6/20),0)

[pmw19800]

i didn’t, think i overcomplicated it in my head

thanks ALi

[AliGW]

We all do that sometimes! Glad to have helped you to clear the mist.