IF statement wont work correctly

[dannyshezo]

Hello, im trying to get this IF statement to work correctly:

Please Login or Register  to view this content.

The aim is to display only calculations for tarrif B in tarrif B call charges, but when i drag the formula down it will calculate it for tarrif A and C. (This should make more sense in the attachment)

Hope someone can help me, thanks

[timbo1957]

How about -

=IF(RIGHT(G6,1)="B",IF(AND(C7=$A$3,D7<$C$3),0,D7*$E$2),"")

[brokenbiscuits]

You have the true and false parts of the statement the wrong way around.

Try:

=IF(AND(C7=$A$3,D7<$C$3),D7*$E$2,0)

[brokenbiscuits]

Having looked at the problem properly,

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

would work much better!

[dannyshezo]

Will give that go thanks

[dannyshezo]

How about -

=IF(RIGHT(G6,1)="B",IF(AND(C7=$A$3,D7<$C$3),0,D7*$E$2),"")

The problem with this is that when i drop and drag it for the rest it wont actually display anything for any other

[dannyshezo]

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

[brokenbiscuits]

Sorry, missed off a $

Cell G7:
=IF(AND($C7=$A$3,$D7>$C$3),($D7-$C$3)*$E$3,0)

Change the 3s to 2s for A and 4s for C

[dannyshezo]

Its now displaying the costs for B but still displays 0 for all the rest, i should of said, i need it to display nothing if its in tarrif A and C under call charges B

Ive uploaded what it looks like now

[brokenbiscuits]

Ok, last chance 'cause I'm off home:

=IF($C7<>$A$3,"",IF($D7>$C$3,($D7-$C$3)*$E$3,0))

?

[dannyshezo]

Thank you it works