I need help creating two formulas. I'm hoping this can be done with some
variation of a function, such as IF, SUMIF, etc. I'd like to avoid using VBA
if at all possible.

1. For the first formula: if there is an amount in column A, multiply that
amount by 5% and place it in column F

2. Second formula: if the date value in column B is within the current
month, multiply the amount in column A by 40% and place it in column G

Assuming data running in A2 down

1. In F2:
=IF(ISNUMBER(A2),A2*5%,"")

2. In G2:
=IF(AND(ISNUMBER(A2),TEXT(B2,"mmmyy")=TEXT(TODAY() ,"mmmyy")),A2*40%,"")

Select F2:G2, copy down as far as required
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Candace" wrote:
I need help creating two formulas. I'm hoping this can be done with some
variation of a function, such as IF, SUMIF, etc. I'd like to avoid using VBA
if at all possible.

1. For the first formula: if there is an amount in column A, multiply that
amount by 5% and place it in column F

2. Second formula: if the date value in column B is within the current
month, multiply the amount in column A by 40% and place it in column G

Hello
Formula in F1:
=IF(ISNUMBER(A1),A1*5%,0)

Formula in G1
=IF(MONTH(B1)=MONTH(TODAY()),A1*40%,0)

HTH
Cordially
Pascal

"Candace" a écrit dans le message de
news: ...
I need help creating two formulas. I'm hoping this can be done with some
variation of a function, such as IF, SUMIF, etc. I'd like to avoid using
VBA
if at all possible.

1. For the first formula: if there is an amount in column A, multiply that
amount by 5% and place it in column F

2. Second formula: if the date value in column B is within the current
month, multiply the amount in column A by 40% and place it in column G

1. =IF(A1<"",A1*5%,"")

2. =IF(TEXT(B1,"mmm yyyy")=TEXT(TODAY(),"mmm yyyy"),A1*40%,"")
An alternative here is to use an AND with tests on MONTH(B1) and YEAR(B1),
but the TEXT route is probably shorter.
--
David Biddulph

"Candace" wrote in message
...
I need help creating two formulas. I'm hoping this can be done with some
variation of a function, such as IF, SUMIF, etc. I'd like to avoid using
VBA
if at all possible.

1. For the first formula: if there is an amount in column A, multiply that
amount by 5% and place it in column F

2. Second formula: if the date value in column B is within the current
month, multiply the amount in column A by 40% and place it in column G