I have a formula that does exactly as I want, but now I need to add something to say if the result is positive, enter the value. If the result is negative, enter 0
Is there a way to do this?
=VLOOKUP(A7,EVENING_Data!A$1:P$600,16,FALSE)
I have a formula that does exactly as I want, but now I need to add something to say if the result is positive, enter the value. If the result is negative, enter 0
Is there a way to do this?
=VLOOKUP(A7,EVENING_Data!A$1:P$600,16,FALSE)
Last edited by mmann1973; 01-08-2014 at 07:00 PM. Reason: solution posted
Yes, and it should be quite easy, just wrap the MAX-function around it, like this:
=MAX(VLOOKUP(A7,EVENING_Data!A$1:P$600,16,FALSE), 0)
Best regards
Per Erik Midtr?d
That's exactly what I needed!!!!
What if I want the value to be below 0?
Nevermind....tried =MIN(VLOOKUP(A7,EVENING_Data!A$1:P$600,16,FALSE), 0) and it worked like a charm
THANKS!!!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks