agwalsh
asked on
And/if formula not working - faulty logic on my part suspected!
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([@[Deferr ed %]]<100%,[@[Deferred %]]=0%,[@[Revenue Date2]]="no"),0,IF(AND([@[ S&M Contract Start date]]=[@[Revenue Date]],),"([@Amount]*(1-[@ [Deferred %]])+[@Amount]/[@[Revenue Days]]",[@Amount]/[@[Reven ue Days]])),0%)
.=IFERROR(IF(AND([@[Deferr
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Check the two values that are checked to ensure that they are:
Rate - Exactly 100% or 0%
Date2 - no (case shouldn't be an issue)
Rate - Exactly 100% or 0%
Date2 - no (case shouldn't be an issue)
ASKER
@Rob Henson - will do that..thanks a mil. Ah, it's always the simple things isnt' it? :_)
ASKER
the 100% was fine - the file kept crashing and not updating the values...but that was the solution. Thanks as always.
ASKER
As always when you are down a rabbit hole, come to Experts Exchange - and Rob Henson in particular :-) to sort the problem.
Thank you for the great feedback.
ASKER
=IFERROR(IF(AND(OR([@[Defe
Still getting an actual amount there grrrr