Conditional Formula Issue

[belly247]

Hi,

I'm trying to put together a spreadsheet where cell G5 has several possible dollar amounts based on the data in F5. For example, if the amount in F5 is between $0 -$9999 then the amount in G5 is $19.95, if however the amount in F5 is between $10,000 and $24,999 then the dollar amount in G5 should be $29.95. Finally, if the amount in F5 is more than $25,000 then the figure to be added is 0.12% of this amount in G5. I hope this makes sense!

I have limited experience with Excel and am completely stuck so any and all help would be very gratefully received!

[ragulduy]

=if(f5<=9999,19.95,if(f5<=24999,29.95,f5/100*0.12))

[belly247]

Wow Yudlugar, that was fast!! Thankyou very much for your help