Formulas

[Mira]

I have 5 columns and need a formula to help calculate a
prize. The columns contain the following formulas:
C: non-locked to enter # of winners
D: =ROUNDUP(E10/C10,0)
E: =IF(C41>F10,F10,C41)
F: locked - contains the max payout allowed
G: =(D10*C10)-E10

These are the columns I have. My problems is that I need a
formula in D that will give me the payout amount, BUT, the
payout cannot be less than $5.

I.E. the max payout allowed in 'F' is $80, but I have 22
winners entered in 'C' which is $3.63 rounded to $4 (all
payouts have to be rounded UP to the nearest dollar).
However, the amount in 'D' cannot be less than $5.
Column 'G' calculates the amount paid out over the fixed
amount.

Can anyone help me with this formula, or do I need another
column and, if so, how do I get them to relate to the
other formulas (9 page workbook).

Mira

 

[GB]

If I understand you correctly , here's one way:

D10: =MIN(5, ROUNDUP(E10/C10,0))

Actually I think you mean Max not Min. Max will give you the greater of $5
or the roundup formula.

Geoff