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.
|