software

what i want to do is make a formule that will add £0.50 to any value over
£20.00 but to add £0.25 to any value under £20.00.
i know it can be done but i can't remember how to do it

=IF(A1=quot;quot;,quot;quot;,IF(A1gt;=20,A1 0.5,A1 0.25))

--
Regards,

Peo Sjoblom

Portland, Oregon

quot;Paulo Coelhoquot; lt;Paulo gt; wrote in message
...
gt; what i want to do is make a formule that will add £0.50 to any value over
gt; £20.00 but to add £0.25 to any value under £20.00.
gt; i know it can be done but i can't remember how to do itHi Paulo,

if you have the £20.00 in cell A1 then go to cell b1 and enter:
=IF(A1lt;20,A1 0.25,A1 0.5).

Hope this helps

-------------
Michael Gill
- If you found this post useful please press quot;Yesquot; under the quot;Was this post
helpful sectionquot; - Thanks quot;Paulo Coelhoquot; wrote:

gt; what i want to do is make a formule that will add £0.50 to any value over
gt; £20.00 but to add £0.25 to any value under £20.00.
gt; i know it can be done but i can't remember how to do it