Thread: OR function
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SKCDPH-JHS SKCDPH-JHS is offline
external usenet poster
 
Posts: 3
Default 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