Using the "or" with "if"
 

Here is my command:

=IF(D16(D15*0.85),D16*0.01)

Now I also want to add and "or" type command he

=IF(D16(D15*0.85)or (E16E15),D16*0.01)

How would I write it out?

Using the "or" with "if"
 

=IF(OR(D16(D15*0.85),E16E15),D16*0.01

--
Message posted from http://www.ExcelForum.com

Using the "or" with "if"
 

Hi Dwayne,

=IF(OR(D16D15*.85,E16E15),D16*0.01,"")

or (guessing these are percentages)

=IF(OR(D16D15*85%,E16E15),D16*1%,"")


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Dwayne Hoover" wrote in message
om...
Here is my command:

=IF(D16(D15*0.85),D16*0.01)

Now I also want to add and "or" type command he

=IF(D16(D15*0.85)or (E16E15),D16*0.01)

How would I write it out?

Using the "or" with "if"
 

Dwayne

=IF(OR(D16D15*0.85,E16E15),D16*0.01)

Regards
Peter
-----Original Message-----
Here is my command:

=IF(D16(D15*0.85),D16*0.01)

Now I also want to add and "or" type command he

=IF(D16(D15*0.85)or (E16E15),D16*0.01)

How would I write it out?
.