Microsoft Office Forums - View Single Post - [Solved] Help with formula please.

Thread: [Solved] Help with formula please.

View Single Post

Old

04-05-2011, 08:50 PM

Kaneto

Kaneto is offline

Kaneto uses Windows 7

Windows 7

Kaneto uses Office 2010 (Version 14.0)

Office 2010 (Version 14.0)

Competent Performer

Join Date: Nov 2010

Posts: 136

Kaneto is on a distinguished road

Default

Quote:

Originally Posted by macropod

View Post

Hi Andrew,

I'd suggest:
=MIN(1,400/A1)

Even better. I knew there was an easier way to accomplish this but I just could not remember it.

Reply With Quote