Function Formulas

[nfdupont]

I cannot create a formula for a simple function related problem. If A1
equals the number of calls a fire department gets in a month (200), and
B1 is the number of calls a single fireman responds to (60), and C1 is
the percentage of calls the fireman in B1 responds to, BUT it cannot
exceed 25% no matter how many calls the fireman responds to (in this
example, the cutoff would be 50), how do I write the formula for the
cell in C1?
I know the first part is (B1*100)/A1, but I am lost after this point.
Any one who can help me I am very grateful to. Happy New Year. A
fireman needing formual help

 

[Helpful Harry]

I cannot create a formula for a simple function related problem. If A1
equals the number of calls a fire department gets in a month (200), and
B1 is the number of calls a single fireman responds to (60), and C1 is
the percentage of calls the fireman in B1 responds to, BUT it cannot
exceed 25% no matter how many calls the fireman responds to (in this
example, the cutoff would be 50), how do I write the formula for the
cell in C1?
I know the first part is (B1*100)/A1, but I am lost after this point.
Any one who can help me I am very grateful to. Happy New Year. A
fireman needing formual help

If I understand that correctly, then you're looking for an 'If'
function that says ...

If (B1*100)/A1 is more than 25% then make the cell display 25%
otherwise display the result of (B1*100)/A1

that gives and Excel function of ...

If((B1*100)/A1 > 0.25, 0.25, (B1*100)/A1)

(As long as cell C1 is formatted to display as a percentage.)


Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

 

[JE McGimpsey]

I cannot create a formula for a simple function related problem. If A1
equals the number of calls a fire department gets in a month (200), and
B1 is the number of calls a single fireman responds to (60), and C1 is
the percentage of calls the fireman in B1 responds to, BUT it cannot
exceed 25% no matter how many calls the fireman responds to (in this
example, the cutoff would be 50), how do I write the formula for the
cell in C1?
I know the first part is (B1*100)/A1, but I am lost after this point.
Any one who can help me I am very grateful to. Happy New Year. A
fireman needing formual help

One way:

Assuming that you'd like 25% to be reported as 25:

=MIN(B1*100/A1,25)