I've got a nice juicy formula here. So what I want to happen is this..if the entry in the entry in the Deferred % column is ANYTHING but 100% or 0% and the revenue date 2 is no, I should get a calculation. If the Deferred% is 100% or 0%, or the REvenue date 2 is no, I should get 0. At the moment I am testing this on a deferred % with 100% and I am getting a number. I'm now not seeing it clearly but I'm guessing I am screwed up in the And logic bit of the formula. Thanks. !
.=IFERROR(IF(AND([@[Deferred %]]<100%,[@[Deferred %]]=0%,[@[Revenue Date2]]="no"),0,IF(AND([@[S&M Contract Start date]]=[@[Revenue Date]],),"([@Amount]*(1-[@[Deferred %]])+[@Amount]/[@[Revenue Days]]",[@Amount]/[@[Revenue Days]])),0%)