Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Functions & Formulas | Excel Worksheet Functions | |||
Functions and Formulas | Excel Worksheet Functions | |||
Formulas with if functions???? | Excel Discussion (Misc queries) | |||
What Formulas or Functions to use??!!! | Excel Discussion (Misc queries) | |||
Functions and formulas | Excel Discussion (Misc queries) |