• 460K Members
• 13K Online
• 557K Conversations

## Excel formula help

Occasional Visitor

# Excel formula help

I want my formula to be a cell * a number to a maximum of 2000

so for example:

If A1*.05 equals more than 2,000 I want the Max amount to show in the cell as 2,000

If it's under 2,000 than the number can be whatever the calculation.

3 Replies

# Re: Excel formula help

Hello,

try this:

=MIN(A1*0.5,2000)

The min function will show the smallest of the values. If A1*0.5 is less than 2000, that result will be shown. If it is greater than 2000, the cell will show 2000, because that is the smaller of the two values.

The long way to write this is

=if(A1*0.5<2000,A1*0.5,2000)

# Re: Excel formula help

Hi.

I am merging data from Excel to Word.  The format of the date in the Excel File is dd-mm-yy.

When I merge to my Word Document, the date appears in American Format.

e.g. 06-Nov-2015 appears as 11/6/15.

How can I correct this to appear in UK format -  i.e. 6/11/15   or even 06 November 2015?

Frank

# Re: Excel formula help

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies