Formula help?

[Jerry]

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.

 

[Bob I]

=Max(a1*2,.50)

 

[Stephen]

In B1 put the formula
=MIN(0.5,2*A1)
Copy this formula down column B as far as your data goes in column A.

 

[Carim]

Hi,

If I understand correctly your question :

=CEILING(A1*2,0.5)

HTH

 

[Marcelo]

try it

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

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



"Jerry" escreveu:

 

[David Biddulph]

For MIN read MAX, Stephen?
--
David Biddulph

In B1 put the formula
=MIN(0.5,2*A1)
Copy this formula down column B as far as your data goes in column A.

 

[Stephen]

OK! I'm going to give up for today!!!

For MIN read MAX, Stephen?

 

[Jerry]

Great! Thanks Bob 1 and to all as well!

=Max(a1*2,.50)

 

[Bob I]

You're welcome, have a great day!

Great! Thanks Bob 1 and to all as well!

: