| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to set up an IF formula
formula: sum(B1-C1)/C1. B1 is 200, C1 is 100 result is 100%. But when B1 is
(200) and C1 is (100) the result is still 100% but should be (100%). How can I set-up formula so it correctly recognizes both circumstances? As always thank YOU. -- Gene |
Threaded Mode
