How?

K

kasutaja

Is there possible to make one formula for below problem?

a b c d e
JOHN 036023 61660 GARDEN 64
JOHN 036023 61660 ELECTRIC 5749
JOHN 036023 61660 HOME 58
JOHN 036023 61660 METAL 2112
JOHN 036023 61660 SAN 5523
JOHN 036023 61660 PAINT 24436
JOHN 036023 61660 BUILDING 23719
ANN 014038 30662 PAINT 6908
ANN 014038 30662 BUILDING 23754
BILL 111525 23543 GARDEN 319
BILL 111525 23543 ELECTRIC 886
BILL 111525 23543 HOME 262
BILL 111525 23543 METAL 63
BILL 111525 23543 PAINT 1469
BILL 111525 23543 BUILDING 20545
GEORG 040450 20583 METAL 0
GEORG 040450 20583 PAINT 0
GEORG 040450 20583 BUILDING 20583

If the C value for the salesman is > than 25000 formula writes “OKâ€, but if
the C value is < than 25000 he looks E and searches for the word BUILDING and
if E value for BUILDING is < than 14000 he writes “OKâ€. Other ways he writes
“NOâ€.
So for example:
JOHN – “OKâ€
ANN – “NOâ€
BILL – “NOâ€
GEORG – “NOâ€

Thank you.
K.L.
 
D

Don Guillett

If I understood correctly, try this
=IF(C10>25000,"ok",IF(AND(E10<14000,D10="building"),"ok","no"))
 
E

Eduardo

Hi,

=IF(C10>25000,"ok",IF(AND(C10<25000,E10<14000,D10="building"),"ok","no"))

if this helps please click yes thanks
 
Top