G
Guest
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
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