If Statement with Multiple Conditions

[HC]

I'm having a problem figuring out this IF statement.

In cell D1: =IF(A1=3,R4,IF(A1=2,R5, and the third part IF(A1=1and
N1>0,R6,"")))

If A1 equals 1 and (A1=1 and N1>0) are not met then D1 is left blank.

I can get it to work up to the point where (A1=1 and N1>0) have to be met
before inserting the price in R6 into D1.

Can someone show me how to write this statement?

 

[A.W.J. Ales]

HC,

=IF(A1=3,R4,IF(A1=2,R5, IF(AND(A1=1,N1>0),R6,"")))


--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

 

[HC]

Thanks Auk,

That worked perfectly. It seemed like there should be an "AND" in there but
I could not figure out how and where to put it.
I appreciate the response.

HC

 

[A.W.J. Ales]

You're welcome HC

Remember AND (and OR and ...) is as fas as Excel is concerned just a
function and therefore the same rule applies as for each other Excel
function.

Functionname(Argument1 , Argument 2 , and so on)

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *