Formula help?
 

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.

Formula help?
 

=Max(a1*2,.50)

Jerry wrote:

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.

Formula help?
 

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.

"Jerry" wrote in message
...
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.

Formula help?
 

Hi,

If I understand correctly your question :

=CEILING(A1*2,0.5)

HTH

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.

Formula help?
 

For MIN read MAX, Stephen?
--
David Biddulph

"Stephen" <none wrote in message
...
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.

"Jerry" wrote in message
...
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.

Formula help?
 

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

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
For MIN read MAX, Stephen?
--
David Biddulph

"Stephen" <none wrote in message
...
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.

"Jerry" wrote in message
...
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.

Formula help?
 

Great! Thanks Bob 1 and to all as well!

"Bob I" wrote:

=Max(a1*2,.50)

Jerry wrote:

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.

Formula help?
 

You're welcome, have a great day!

Jerry wrote:
Great! Thanks Bob 1 and to all as well!

"Bob I" wrote:


=Max(a1*2,.50)

Jerry wrote:


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.