Hello everyone,
I am trying to solve for how much months of supply for something but also want it to be broken down by either the first or second decimal so if its less than 1 it it will say .77 and as of now it displays 0. I would greatly appreicate the help. Thank you for your time. Cheers.
=IF(BN5>=W5,IF(BN5>=W5+X5,IF(BN5>=W5+X5+Y5,IF(BN5>=W5+X5+Y5+Z5,IF(BN5>=W5+X5+Y5+Z5+AA5,IF(BN5>=W5+X5+Y5+Z5+AA5+AB5,IF(BN5>=W5+X5+Y5+Z5+AA5+AB5+AC5,IF(BN5>=W5+X5+Y5+Z5+AA5+AB5+AC5+AD5,IF(BN5>=W5+X5+Y5+Z5+AA5+AB5+AC5+AD5+AE5,9,8),7),6),5),4),3),2),1),0)
Bookmarks