Thread
:
help with Formulas/Functions
View Single Post
#
3
Posted to microsoft.public.excel.misc
papou[_3_]
external usenet poster
Posts: 31
help with Formulas/Functions
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
Reply With Quote
papou[_3_]
View Public Profile
Find all posts by papou[_3_]