Rounding Down an IF formula???

D

Dagre21

Anyone know how to round down an if formula?

Below is a formula I am using to compute ages. I don't not hav
everyone's birthdate, so I had to use an IF function so nothing i
displayed if no birthday was given.


=IF(C9>0, ($A$3-C9)/365.25, " ")



Thanks for the help
 
P

Peo Sjoblom

Use either

=DATEDIF(C9,A3,"Y")

or

=FLOOR(IF(OR(C9="",A3=""),0, ($A$3-C9)/365.25),1)

the latter I changed since you have at least one bad habit, don't ever put a
space in a cell when you want it to look empty

2. dodge other possibiliyies and 3 use zero if the condition
is true or else the round formula will return error

Regards,

Peo Sjoblom

I would use the datedif formula though,
I also rounded to whole year, I assume that's what you wanted

Regards,

Peo Sjoblom
 
Top