View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Candace Candace is offline
external usenet poster
 
Posts: 22
Default help with Formulas/Functions

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