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

Hello RicBanister, Perhaps you're looking for this formula?=IF(C9<D9,D9,C9)

Forum Discussion

Copper Contributor

Jul 09, 2021

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