TODAY() function

  • Thread starter Thread starter sajida.x
  • Start date Start date
S

sajida.x

i am doin a worksheet on car insurance for a computing project. one o
the criteria is that if a customer is under the age of 25, 5 point
will be added to his record. if the refernce for the cell is E10 wa
formula would i use? am i using the rong funcion
 
Assuming that cell b1 has the age ie:24, in cell c1
=if(b1<25,5,0)
 
Oops. You did say today so if customer date of birth as a date
where i2 has the date

=if(DATEDIF(I2,TODAY(),"Y")<25,5,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

Timesheet - Formula 3
Copying data from one workbook to another dependent on user select 1
Formula Needed! 2
if condition 2
changed DOB to age, but if no DOB need cell to be empty. 4
Help With Nested SumIf / Or 3
how do you include todays date in SUMIF formulas 1
Counting Formula 1

Back
Top