IF statement wont work correctly

**brokenbiscuits** · 11-04-2011, 12:29 PM

Having looked at the problem properly,

=IF(AND($C10=$A$3,$D10>$C$3),($D10-$C3)*$E$3,0)

would work much better!

**dannyshezo** · 11-04-2011, 12:31 PM

Will give that go thanks

**dannyshezo** · 11-04-2011, 12:38 PM

Originally Posted by brokenbiscuits

Having looked at the problem properly,

=IF(AND($C10=$A$3,$D10>$C$3),($D10-$C3)*$E$3,0)

would work much better!

For some reason this one is calculating for tarrif A and C still but displays everything as 0

Re: IF statement wont work correctly