Double Formula

[RWW]

Is it possible to have two formulas in one cell? I charge 10% fee however I charge minimum $50.00.
Example: Cell D2 is $5400.00, Cell E2 w/ formula (=D2*0.1) automatically becomes $540.00 (I understand that)

However how do I make that same cell E1 w/ formula (=D1*0.1) give me $50.00 if D1 is only $360.00?

Example:
A B C D E F G
1 568339-3 5/3/06 NicolE Armijo $360.00 $50.00 $15.00 $5.00
2 568341-8 6/2/06 Charles Harris $5,400.00 $540.00 $162.00 $54.00
3 568342-1 6/2/06 Ronald Zajac $630.00 $63.00 $18.90 $6.30
4 568343-4 6/3/06 Michael Schlie $450.00 $50.00 $15.00 $5.00
5 568344-7 6/3/06 Michael Schlie $1,800.00 $180.00 $54.00 $18.00

 

[babycody]

Book1
	A	B	C	D
1	$ 360.00	$ 50.00
2	$ 499.00	$ 50.00
3	$ 555.00	$ 55.50
4
Sheet5

 

[Barry Katcher]

=IF(D2*0.1<50,50,D2*1)

 

[pgc01]

Hi RWW

You can also use

in E1

 =max(50,D1*0.1)