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

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

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?

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

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

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?