Thread
:
HOW DO I ADD AMOUNTS FOR DIFERENT VALUES
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
Posts: n/a
HOW DO I ADD AMOUNTS FOR DIFERENT VALUES
=IF(A1="","",IF(A1=20,A1+0.5,A1+0.25))
--
Regards,
Peo Sjoblom
Portland, Oregon
"Paulo Coelho" <Paulo
wrote in message
...
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
Reply With Quote