mcdonnella
New Member
- Joined
- Dec 23, 2003
- Messages
- 1
I need help sorting out an if statement to work out the below
=IF(C27=0,0,SUM(H27/(C27-I27-S27-T27)))
the problem I have is that when h27=0 c27=1 i27=1 s27=0 t27=0 the formula comes back as an error
if I do the below formula then it shows as 0% which is what I want.
=IF(ISERROR(SUM(H28/(C28-I28-S28-T28))),0,SUM(H28/(C28-I28-S28-T28))*IF(C28=0,0,SUM(H28/(C28-I28-S28-T28))))
But when I try the second formula on a selection where the below are the values then it comes back as 72% when on the original formula says it should be 84.8%
h27=28 c27=33 i27=0 s27=0 s27=0
any help would be much appreciated
=IF(C27=0,0,SUM(H27/(C27-I27-S27-T27)))
the problem I have is that when h27=0 c27=1 i27=1 s27=0 t27=0 the formula comes back as an error
if I do the below formula then it shows as 0% which is what I want.
=IF(ISERROR(SUM(H28/(C28-I28-S28-T28))),0,SUM(H28/(C28-I28-S28-T28))*IF(C28=0,0,SUM(H28/(C28-I28-S28-T28))))
But when I try the second formula on a selection where the below are the values then it comes back as 72% when on the original formula says it should be 84.8%
h27=28 c27=33 i27=0 s27=0 s27=0
any help would be much appreciated
