Forum Discussion
Solved
Need a second excel formula
This is what I have as my first formula =INT(YEARFRAC(B2,TODAY()))*100 and I need a second formula to return the number 50 IF the first formula results in a 0. I need the second formula to work afte...
Hello Catmandu56,
Is this what you're looking for?
=IF(INT(YEARFRAC(B2,TODAY()))*100=0,50,INT(YEARFRAC(B2,TODAY()))*100)
Hello Catmandu56,
Is this what you're looking for?
=IF(INT(YEARFRAC(B2,TODAY()))*100=0,50,INT(YEARFRAC(B2,TODAY()))*100)
PReagan Yes, yes yes. Thank you