OR function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Can you get E1/F0=0 without E0=0? If not, you don't need the OR().
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Whats wrong with this array formula 7
Averaging many non-contiguous cells if they are blank 1
Average IF? 1
Averages with conditions.... 1
Help requested for nested conditional formulas referencing other c 3
Calculate Count of Days & Average WHERE Amount <>0 1
Nested IF Function problem for Excel 2003 7
filtering subtotals and if functions 2

Back
Top