if then statement

S

steven

when using an if then statement can you use "and"? for
example, if(a2>=0,if(d7>=a5"and"h8>=a5..........
 
D

Dave Peterson

=if(a2>0,if(and(d7>=a5,h8>a5),....

is one way.
when using an if then statement can you use "and"? for
example, if(a2>=0,if(d7>=a5"and"h8>=a5..........
Click to expand...
 
B

Bernard Liengme

Use =IF(a2>=0,IF(AND(D7>=A5,H8>=A5),....
or =IF(a2>=0,IF(D7>=A5)*(H8>=A5), ...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count the remaining weekdays in a data range excluding holidays and start/end dates 5
Paper 6 x 9 inches 3
Using Drop Down list to an If Statement to another Drop Down list 3
Dynamic pointing to a cell 0
Compare last digit in 5 cells for match 0
Page numbering with Merged Document and IF statements 1
how to calculate the difference of values (numbers) in a column? 1
Using multiple IF conditions 3

Top