Hello, I'm hoping someone can help because I've scratched my head pretty hard on this one. I'm trying to do an if function for modeling subscription fees for a software company. The hard part comes when the three subscription levels release in different months. I need to show what percentage of customers will adopt certain subscription levels BUT not if the subscription level hasn't even been released yet. I hope that makes sense and I've attached a screenshot to help. The below formula is producing a $1 result but should be about $237. Can someone help?
Thank You!!
Jeff
=((IF(AND(H15=0,H16=0),BG6,(IF(AND(H15>0,H16=0),BH6,(IF(AND(H16>0),BI6)))*((IF(H$2>=$BA14,$BA14<>0))*((H4-G4)*$C14*$B14)*H11)))))
Screen Shot 2013-05-21 at 1.57.32 PM.jpg
Bookmarks