Date-dependent calculation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want a cell to show the product of the value in cell A4 X 1.04, but only if
the actual calendar date date is past a certain date. So far, I have

=IF(??????,PRODUCT(A4, 1.04))

Can anyone help me fill in the ????. The idea would be: if we've passed
March 31, the date displayed in this new cell would equal to 104% of the
value in A4.
 
=IF(TODAY()>DATE(2007,3,31),A1*1.04,0)

and if it not? .... above will set cell to 0
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculations 1
Find last date of sold stock and sold price. 2
Excel =SUM(A1=A1+B1) 0
Excel Function - Date evaluation 2
ACCRUED INTEREST (ACCRINT) Bug 2
using worksheet name in a formula but not current worksheet 3
Adding days to a date - changed in Excel 2010 8
Using two Vlookup in one Cell 1

Back
Top