| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
OR function
Given that column E lists an "Available Amount", and column F lists an
"Average Amount", I want the following result in column G: IF "Available Amount"=0, then "Complete", else, "Available Amount"/"Average Amount" OR IF "Average Amount"=0, then "Not started", else, "Available Amount"/"Average Amount" How do I write this formula? -- SKCDPH-JHS |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
OR function
=IF(E2=0,"Complete",IF(F2=0,"Not started",E2/F2))
"SKCDPH-JHS" wrote: Given that column E lists an "Available Amount", and column F lists an "Average Amount", I want the following result in column G: IF "Available Amount"=0, then "Complete", else, "Available Amount"/"Average Amount" OR IF "Average Amount"=0, then "Not started", else, "Available Amount"/"Average Amount" How do I write this formula? -- SKCDPH-JHS |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
OR function
Hi there,
If I've read everything right, it should be: =IF(E1=0,"Complete",IF(OR(E1/F1=0,F1=0),"Not started",E1/F1)) There is an issue if column F is blank though, resulting from the first part of the OR clause. (Divides by zero.) Ken Puls, CMA - Microsoft MVP (Excel) www.excelguru.ca SKCDPH-JHS wrote: Given that column E lists an "Available Amount", and column F lists an "Average Amount", I want the following result in column G: IF "Available Amount"=0, then "Complete", else, "Available Amount"/"Average Amount" OR IF "Average Amount"=0, then "Not started", else, "Available Amount"/"Average Amount" How do I write this formula? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
OR function
Perfect, thanks so much!
-- SKCDPH-JHS "SKCDPH-JHS" wrote: Given that column E lists an "Available Amount", and column F lists an "Average Amount", I want the following result in column G: IF "Available Amount"=0, then "Complete", else, "Available Amount"/"Average Amount" OR IF "Average Amount"=0, then "Not started", else, "Available Amount"/"Average Amount" How do I write this formula? -- SKCDPH-JHS |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
OR function
Perfect, thanks so much!
-- SKCDPH-JHS "Teethless mama" wrote: =IF(E2=0,"Complete",IF(F2=0,"Not started",E2/F2)) "SKCDPH-JHS" wrote: Given that column E lists an "Available Amount", and column F lists an "Average Amount", I want the following result in column G: IF "Available Amount"=0, then "Complete", else, "Available Amount"/"Average Amount" OR IF "Average Amount"=0, then "Not started", else, "Available Amount"/"Average Amount" How do I write this formula? -- SKCDPH-JHS |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
OR function
Can you get E1/F0=0 without E0=0? If not, you don't need the OR().
-- David Biddulph "Ken Puls" wrote in message ... Hi there, If I've read everything right, it should be: =IF(E1=0,"Complete",IF(OR(E1/F1=0,F1=0),"Not started",E1/F1)) There is an issue if column F is blank though, resulting from the first part of the OR clause. (Divides by zero.) Ken Puls, CMA - Microsoft MVP (Excel) www.excelguru.ca SKCDPH-JHS wrote: Given that column E lists an "Available Amount", and column F lists an "Average Amount", I want the following result in column G: IF "Available Amount"=0, then "Complete", else, "Available Amount"/"Average Amount" OR IF "Average Amount"=0, then "Not started", else, "Available Amount"/"Average Amount" How do I write this formula? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
| Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
| Date & Time | New Users to Excel | |||
| Conversion | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Linear Mode
