Hello, im trying to get this IF statement to work correctly:
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)![]()
=IF(AND(C7=$A$3,D7<$C$3),0,D7*$E$2)
Hope someone can help me, thanks
Bookmarks