In excel 2007 I have used the LARGE function to return the result that I want but if the condition does not apply the cell returns #NUM! This consequently affects my conditional formatting of the results column. If the condition is not fulfilled I want to return a zero value in the cell. Help ! bearing in mind i am not a techie.
Hi and welcome to the forum.
Something like this?
=IFERROR(LARGE(A1:A10;1);0)
Edit: Change semi colons to comma, if you have to do this.
Last edited by Fotis1991; 05-17-2012 at 04:51 AM. Reason: Edit
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Fotis - Success-thanks very much - you are a star. If your politicians had your brain Greece would be in a healthier state.
I am now going to post another question, I´m crossing my fingers that you can help me again !!
Ηι
You are welcome. Thank you for your good words.
Many of them(Our politicians) have better brain than me.
But using it the wrong way ....
They are using their minds for them to prosper and the people nearby. Not the Greek people.....
These are just .... ... traitors to their people ...
We are very angry with them ..
Thanks again Fotis - good luck in the elections
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks