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
|