| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using the "or" with "if"
|
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) | |||
Linear Mode
