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 after the first one, I have played around with some IF functions but I cannot seem to get it inputted just right for Excel to take it. Please help!! Probably easy for some of you.
Thanks
Hello Catmandu56,
Is this what you're looking for?
=IF(INT(YEARFRAC(B2,TODAY()))*100=0,50,INT(YEARFRAC(B2,TODAY()))*100)
4 Replies
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
