Results 1 to 16 of 16

Problem creating an 'If' formula

Threaded View

  1. #8
    Registered User
    Join Date
    02-17-2010
    Location
    Wirral
    MS-Off Ver
    Excel 2007
    Posts
    26

    Re: Problem creating an 'If' formula

    Excellent! Thank you once more Mr.Ote!

    I've just got one final piece of the jigsaw if you would be able to help with this too.

    On the updated spreadsheet attached I am now looking at Rows 17 and 18. Cell AK17 now correctly identifies that the first valid numerical entry is in the 1st Row. Cell AL17 then counts if the entry is in the first row and the total in the first row > the total in the second row.

    I now want a count in Cell AM17 if the first numerical entry is in the first row, is greater than 19 and the total in the first row > the total in the second row.

    What would be the best way to do this?
    Attached Files Attached Files

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