Setting A Daily Minimum Price

[dharmon]

I need to calculate Price per Hour of service but set a 2 Hour minimum for my services. Thus, if employed for 1 hour, 2 hours of payment is still required.

Result being the below. What do I need to add to "=$A2*$B2" in order to get the minimum of $200 for the first line?

Hours Price Total
1 $100 $200
2 $100 $200
3 $100 $300
3 $100 $300
1 $100 $200

[samba_ravi]

c1

Please Login or Register  to view this content.

=max(2,a1)*b1