IF or AND?

Y

Yanto hendrawan

Help me please... :)

How to make formula for :

A3 contain number of Apples
B3 contain number of Orange

C3 ---> if any number (or >0) in A3 called "Apples" and if any number
(or >0) in B3 called "Orange"
And if both of C3 and D3 contain any number called "BEGO LU"

thanks.. :)
 
A

andy_hammer2001(remove)

Yanto said:
Help me please... :)

How to make formula for :

A3 contain number of Apples
B3 contain number of Orange

C3 ---> if any number (or >0) in A3 called "Apples" and if any number
(or >0) in B3 called "Orange"
And if both of C3 and D3 contain any number called "BEGO LU"

thanks.. :)
Click to expand...
Hi, not sure I understand the last line:

And if both of C3 and D3 contain any number called "BEGO LU"

Do you mean if both A3 and B3 contain a value >0, then you would like
the words "Bego Lu" to appear in Cell C3?
 
A

Arvi Laanemets

Hi

=IF(AND(A2>0,B3=0),"Apples",IF(AND(A3=0,B3>9),"Oranges",IF(AND(A3>0,B3>0),"BEGO
LU","")))



--
Arvi Laanemets
( My real mail address: arvil<at>tarkon.ee )



"Yanto hendrawan"
 
S

Sandy Mann

If it is homework use Arvi's formula. If it is not essential to use If/AND
try:

=CHOOSE((A2>0)+(B2>0)*2+1,"","Apples","Oranges","Bego Lu")

--
HTH

Sandy
[email protected]
Replace@mailinator with @tiscali.co.uk


"Yanto hendrawan"
 
Y

Yanto hendrawan

Thank you Arvi and Sandy.. :)


Next, i want to make a warning word " BEGO LU" (blinking backround)

in D3 if any value in A3:A10 and B3:B10

Could you help me once more?

Thanks.... :
 
A

Arvi Laanemets

Hi

Any value what???

When you want D3 to indicate, is there any empty cell in range A3:B10, then
something like
=IF(COUNTIF(A3:A10,"")=0,"","BEGO LU")
and apply conditional formatting for cell D3 - where with cell value="BEGO
LU" the blinking background is used.


--
Arvi Laanemets
( My real mail address: arvil<at>tarkon.ee )


"Yanto hendrawan"
 
A

Arvi Laanemets

Btw. I'm not sure about blinking background - is it possible at all? I
myself use Excel2000, and seemingly there it isn't possible - at least
without VBA.


--
Arvi Laanemets
( My real mail address: arvil<at>tarkon.ee )


"Yanto hendrawan"
 
Y

Yanto hendrawan

Great....:)

help me please....

I have list of data in d3:d10 and it's explained (description) kind of
data in e3:e10,

(sheet1) like apple(d3), red fruits(e3). If i'll type in b2 (sheet2)
"apple", c2 will

show description of "apple". Is it a macro? how to make it?

Regards,

YH:)
 
R

Roger Govier

Hi Yanto

Try entering in cell D2 of Sheet2
=VLOOKUP(C2,Sheet1!$D$3:$E$10,2,0)
Copy down as required

Regards

Roger Govier
 
Top