Help with Formula

[Joefried]

Hi
thanks for looking at my question

i need help with filling in the following Blank Spot

so far i have this:

=IF(A18="(blank)","",IF(A18="","",VLOOKUP(A:A,'Sheet 2'!C:J,8,FALSE)*C18))

however i would like if the answer is 0.00 continue to look until you find something that's at least 0.01 unless there is no

Best Regards
Joe

 

[GlennUK]

Can you rephrase this, so that it's easier to understand:

i would like if the answer is 0.00 continue to look until you find something that's at least 0.01 unless there is no

... maybe providing examples of what you mean?

 

[prajul89]

I didn't understand what you actually need but try putting 0 in place of "".

 

[Michael M]

Your question is not very clear,but if you want to get rid of the zero
try

=IF(OR(A18="",A18=0),"",VLOOKUP(A:A,'Sheet 2'!C$1:J$65536,8,FALSE)*C18)

 

[Joefried]

Thanks all for looking into this

My question is by the VLOOKUP part because I have more then one line with that result (I sell items and each line is a sale and I want him to bring me back the sale price however if the sale didn't work our the sale price will be 0.00) however since VLOOKUP gets the first result and doesn't continue there is were my question comes in how can I make him continue search if the first result is 0.00

 

[prajul89]

Thanks all for looking into this

My question is by the VLOOKUP part because I have more then one line with that result (I sell items and each line is a sale and I want him to bring me back the sale price however if the sale didn't work our the sale price will be 0.00) however since VLOOKUP gets the first result and doesn't continue there is were my question comes in how can I make him continue search if the first result is 0.00

Thats difficult bro....
I don't know wheater it is possible???

 

[Joefried]

well i was told "if i can think about it Excel can doit"

 

[prajul89]

Ofcourse excel can do it!
But for what you want, you have to build a user defined function. I don't think there is any other way out.

 

[Joefried]

what do you mean by that?

 

[sonumm]

sir can you help me for generates samples sets in excel plz plz help me my set is consists six integers and it has 720 combination to write sample set i cant understand how can i generate sample like my set={1,2,3,4,5,6} and i have to make 720 combination like {6,5,4,3,2,1} plz help me to genrates these sample set on excel 2007 i will be very thankful to you.i m waiting for your reply........as sooooooon as possible plz i have no enough time for my assignment

take care