LinkBack URL
About LinkBacks
=LOOKUP(2,1/(D18:D22<>""),D18:D22)
If the number is negative, I want it to put 0 in the box (not the negative). Can anyone help, please?
Tom
=LOOKUP(2,1/(D18:D22<>""),D18:D22)
If the number is negative, I want it to put 0 in the box (not the negative). Can anyone help, please?
Tom
Try
=MAX(0,LOOKUP(2,1/(D18:D22<>""),D18:D22))
Audere est facere
=if(=LOOKUP(2,1/(D18:D22<>""),D18:D22)<=0,0,=LOOKUP(2,1/(D18:D22<>""),D18:D22))
Not sure if your formula works or not, but that will give you your zero
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
=if(lookup(2,1/(d18:d22<>""),d18:d22)<0,0,lookup(2,1/(d18:d22<>""),d18:d22))
Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
thanks, that's sorted !!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks