#### Private Equity Guy

##### New Member

- Joined
- Oct 2, 2010

- Messages
- 11

Example Cell R4 contains:

=IF(AND('Sales Data by Channel'!$R$1:$V$1>=Assumptions!$C19,'Sales Data by Channel'!$R$1:$V$1<Assumptions!$D19),Assumptions!$C$6,IF(AND('Sales Data by Channel'!$R$1:$V$1>=Assumptions!$D19,'Sales Data by Channel'!$R$1:$V$1<Assumptions!$E19),Assumptions!$C$7,IF(AND('Sales Data by Channel'!$R$1:$V$1>=Assumptions!$E19,'Sales Data by Channel'!$R$1:$V$1<Assumptions!$F19),Assumptions!$B$9,IF('Sales Data by Channel'!$R$1:$V$1>=Assumptions!$F19,Assumptions!$C$9,0))))

and Cell S4 contains:

=IF(AND('Sales Data by Channel'!$S$1:$V$1>=Assumptions!$C19,'Sales Data by Channel'!$S$1:$V$1<Assumptions!$D19),Assumptions!$C$6,IF(AND('Sales Data by Channel'!$S$1:$V$1>=Assumptions!$D19,'Sales Data by Channel'!$S$1:$V$1<Assumptions!$E19),Assumptions!$C$7,IF(AND('Sales Data by Channel'!$S$1:$V$1>=Assumptions!$E19,'Sales Data by Channel'!$S$1:$V$1<Assumptions!$F19),Assumptions!$B$9,IF('Sales Data by Channel'!$S$1:$V$1>=Assumptions!$F19,Assumptions!$C$9,0))))

I know the problem is due to a FALSE statement because I changed the FALSE value to 1 and the fields equaled 1.

Please help as I need to finish this by end of business today.