if statement 3 conditions-dumb question

[engineer33]

guys i know this might be a dumb question
here it is

basically i have 3 cells

3 conditions

cell 1: 23
cell 2: 40
cell 3: 4

cell 4: answer

=IF((cell2<0)*OR(cell1=0,cell3=""),"",cell4)

it is a bit tricky sorry if this is lame to you.

regards,

 

[shawnhet]

What are you trying to do exactly? I don't think the expression you've written here will give meaningful answers.

Cheers,

 

[engineer33]

i have 4 cells

i need to but 3 conditions

cell1:9
cell2:3
cell3:7


should display if criterial is met
cell4:5000

what i am trying to do is
if cell1 and cell2 are >0
and if cell3 is less <0

than display cell 4

 

[jproffer]

=IF((cell2<0)*OR(cell1=0,cell3=""),"",cell4)

You can't multiply something by the result of an or statement, I don't get that part. OR do you mean, (IF cell2 is less than zero, or cell1 = 0, or cell3 = "") ?? 3 tests within the or statement??

Then if the IF statement returns false, you want to return the value of cell4?

 

[jproffer]

=IF(AND(AND(Cell1>0,Cell2>0),Cell3<0),Cell4,"")

If false it will do nothing and show nothing, as written.

 

[shawnhet]

what i am trying to do is
if cell1 and cell2 are >0
and if cell3 is less <0

than display cell 4

Based on what you say here, try:

=If(AND(A1>0,A2>0,A3<0),A4,"")

where A1,A2,A3 AND A4 are cells 1-4, respectively.

Cheers,

 

[jproffer]

HAHAHA...don't know why I nested the ANDs....loss of brain for a second.

Use shawnhet's formula.

 

[engineer33]

Got thank u !!!!