IF THEN ELSE FORMULA

[RicBanister]

I am having trouble trying to create a formula.  I want an if then else formula.  here is what I put in:

=if C9<D9 then D9 else C9.  The cell then puts a:  #NAME? 

Can I get some direction from someone?

Thanks

[#2]

Hello @RicBanister,

Perhaps you're looking for this formula?

=IF(C9<D9,D9,C9)

[#3]

@RicBanister 

Or

=MAX(C9,D9)