Using the "or" with "if"

[Dwayne Hoover]

Here is my command:

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

Now I also want to add and "or" type command here:

=IF(D16>(D15*0.85)or (E16>E15),D16*0.01)

How would I write it out?

 

[green78]

=IF(OR(D16>(D15*0.85),E16>E15),D16*0.01

 

[Bob Phillips]

Hi Dwayne,

=IF(OR(D16>D15*.85,E16>E15),D16*0.01,"")

or (guessing these are percentages)

=IF(OR(D16>D15*85%,E16>E15),D16*1%,"")


--

HTH

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

 

[Peter Atherton]

Dwayne

=IF(OR(D16>D15*0.85,E16>E15),D16*0.01)

Regards
Peter