I'm working to streamline an incentive workbook. How can I work out the following?
IF value (D1) is the MAX in Column (D1:D1500) return 100, if not return 0.
I have spent the day nesting IF statements but I'm stumped on this one.
THANKS!
I'm working to streamline an incentive workbook. How can I work out the following?
IF value (D1) is the MAX in Column (D1:D1500) return 100, if not return 0.
I have spent the day nesting IF statements but I'm stumped on this one.
THANKS!
Last edited by njexpress9; 02-24-2012 at 07:06 PM. Reason: SOLVED
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks