# the maximum and minimum limit

1. ## the maximum and minimum limit

I have a simple multiplication =(10,00,000*1%) the result will be 10,000. and this is the maximum limit.,

if the number is increases the result should be 10000

ir the number decreases the result should be as per the multiplication

is there an easy way to do that?

sethu

2. ## Re: the maximum and minimum limit

Here!

=IF(1000000*1%>10000,10000,1000000*1%)

Deep

3. ## Re: the maximum and minimum limit

Another option:
=MIN(A1*1%,10,000)
Where A1 is variable (1,000,000 or others)

regards
sethu

5. ## Re: the maximum and minimum limit

thank you it works .,thank you very much

=MIN(A1*1%,10,000)
regards
sethu

6. ## Re: the maximum and minimum limit

dear all.,
how can i hide my formula [in formula bar] in a cell from other's view

7. ## Re: the maximum and minimum limit

Assuming the formula is in cell A1.

Select the entire sheet
Within the sheet grid, Right click>Format cells>Protection tab>Unselect Locked
OK out

Select cell A1
Right click>Format cells>Protection tab>Select Locked and Hidden
OK out

There are various options available. Select which options you want then OK out.

8. ## Re: the maximum and minimum limit

thank you very much.,
after protection of the sheet or cell
i want to enter values.,
do you help me.,
regards
sethu

9. ## Re: the maximum and minimum limit

Yu should be able to enter data in other cells. You only protected 1 cell, cell A1 with the formula.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1