Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do I ensure that the sum of two cells does not exceed a set fi
How do I ensure that the resultant sum of two cells A & B expressed as a
percentage in cell C does not exceed a set percentage of say 150%? |
#2
|
|||
|
|||
What do you want to occur if it DOES?
******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "lennysc14" wrote in message ... How do I ensure that the resultant sum of two cells A & B expressed as a percentage in cell C does not exceed a set percentage of say 150%? |
#3
|
|||
|
|||
=min(150%,yourformulahere)
=min(150%,sum(a1,b3)) for example lennysc14 wrote: How do I ensure that the resultant sum of two cells A & B expressed as a percentage in cell C does not exceed a set percentage of say 150%? -- Dave Peterson |
#4
|
|||
|
|||
Thank you Dave
"Dave Peterson" wrote: =min(150%,yourformulahere) =min(150%,sum(a1,b3)) for example lennysc14 wrote: How do I ensure that the resultant sum of two cells A & B expressed as a percentage in cell C does not exceed a set percentage of say 150%? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting empty cells within a range of cells | New Users to Excel | |||
Counting only active cells | Excel Discussion (Misc queries) | |||
Locate and delete specific cells | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |