Thread: Formula help?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default Formula help?

try it

=IF(+A1*2<0.5,0.5,A1*2)

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Jerry" escreveu:

Relatively new to Excel. Need to multiply the currency value in column A by
2. If sum is less than 0.50 round to 0.50 otherwise display sum in colum B.

Thank you, Jerry

PS: Would the latest version in Excel make it easier to write formulas
through the use of some type of wizard? I don't use Excel often, thus
learning and retaining formulas, etc... is not easy.