Round a cell

[bobbijo]

How do I get K cells to rounddown/roundup to the nearest dollar but not to exceed $99.00?

Amount of Papers Sold

Game Number

Game Name

Paper/Packet Serial Number

Packets

Seller 2

Seller3

Total Sold

Selling Price

Gross Receipts

Actual Cash Received

Total Prizes Paid

Number of Winners

Winning Serial Number

1​

9 Pack

6712787/6727968

140​

42​

182​

$1​

$182​

$182​

99.00​

2​

Hardway

6712787/6727968

140​

25​

165​

$1​

$165​

$111​

77.70​

3​

Letter X

6712787/6727968

140​

22​

162​

$1​

$162​

0.00​

4​

Top or Bottom

6712787/6727968

140​

11​

151​

$1​

$151​

0.00​

5​

Block of 6

6712787/6727968

140​

0​

140​

$1​

$140​

0.00​

6​

Champagne Glass

6712787/6727968

140​

0​

140​

$1​

$140​

0.00​

7​

Small Kite

6712787/6727968

140​

0​

140​

$1​

$140​

0.00​

8​

Double Bingo

6712787/6727968

140​

0​

140​

$1​

$140​

0.00​

9​

Small Diamond & 4 Corners

6712787/6727968

140​

0​

140​

$1​

$140​

0.00​

10​

Regular or 4 Corners

6712787/6727968

140​

0​

140​

$1​

$140​

0.00​

11​

5 Around any Corner

6712787/6727968

140​

0​

140​

$1​

$140​

0.00​

12​

4 corners & Any Bingo

6712787/6727968

140​

0​

140​

$1​

$140​

0.00​

13​

Regular Bingo

6712787/6727968

140​

0​

140​

$1​

$140​

0.00​

14​

Coverall

xxxxxxxx

80​

80​

$2​

$160​

$160​

175.00​

$1,780​

351.70​

 

[dreid1011]

Maybe something like this:

=MIN(99,ROUND(K2,0))