Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula help?
Hi,
If I understand correctly your question : =CEILING(A1*2,0.5) HTH |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|