rdowns macrumors Penryn Original poster Jul 11, 2003 27,397 12,521 Dec 19, 2006 #1 I need to write a formula to calcualte a fee. The fee is 8% of a number. The minimum fee is $20 The maximum fee is $80 How would I do that?
I need to write a formula to calcualte a fee. The fee is 8% of a number. The minimum fee is $20 The maximum fee is $80 How would I do that?
bearbo macrumors 68000 Jul 20, 2006 1,858 0 Dec 19, 2006 #2 rdowns said: I need to write a formula to calcualte a fee. The fee is 8% of a number. The minimum fee is $20 The maximum fee is $80 How would I do that? Click to expand... =IF(A1*0.08>20,IF(A1*0.08<80,A1*0.08,80),20) where A1 is your "a number"
rdowns said: I need to write a formula to calcualte a fee. The fee is 8% of a number. The minimum fee is $20 The maximum fee is $80 How would I do that? Click to expand... =IF(A1*0.08>20,IF(A1*0.08<80,A1*0.08,80),20) where A1 is your "a number"
savar macrumors 68000 Jun 6, 2003 1,950 0 District of Columbia Dec 19, 2006 #3 bearbo said: =IF(A1*0.08>20,IF(A1*0.08<80,A1*0.08,80),20) where A1 is your "a number" Click to expand... if(a1>250,(if(a1<1000,a1*.08,80),20)
bearbo said: =IF(A1*0.08>20,IF(A1*0.08<80,A1*0.08,80),20) where A1 is your "a number" Click to expand... if(a1>250,(if(a1<1000,a1*.08,80),20)
rdowns macrumors Penryn Original poster Jul 11, 2003 27,397 12,521 Dec 19, 2006 #5 Thanks. Worked like a charm.
emw macrumors G4 Aug 2, 2004 11,172 0 Dec 19, 2006 #6 What - you're not going to tell us which one you used?