Results 1 to 11 of 11

IF statement wont work correctly

Threaded View

dannyshezo IF statement wont work... 11-04-2011, 12:20 PM
timbo1957 Re: IF statement wont work... 11-04-2011, 12:25 PM
dannyshezo Re: IF statement wont work... 11-04-2011, 12:36 PM
brokenbiscuits Re: IF statement wont work... 11-04-2011, 12:26 PM
brokenbiscuits Re: IF statement wont work... 11-04-2011, 12:29 PM
dannyshezo Re: IF statement wont work... 11-04-2011, 12:31 PM
dannyshezo Re: IF statement wont work... 11-04-2011, 12:38 PM
brokenbiscuits Re: IF statement wont work... 11-04-2011, 12:48 PM
dannyshezo Re: IF statement wont work... 11-04-2011, 12:53 PM
brokenbiscuits Re: IF statement wont work... 11-04-2011, 01:00 PM
dannyshezo Re: IF statement wont work... 11-04-2011, 01:02 PM
  1. #1
    Registered User
    Join Date
    11-03-2011
    Location
    Tamworth, England
    MS-Off Ver
    Excel 2007
    Posts
    12

    IF statement wont work correctly

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

    =IF(AND(C7=$A$3,D7<$C$3),0,D7*$E$2)
    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
    Attached Files Attached Files
    Last edited by dannyshezo; 11-04-2011 at 02:42 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1