Sum IF

[Darin Kramer]

Howdie

I need a formulae to say if h1+i1 is greater than 0, then take
g1/h1+i1.If it is zero then put "ok".

Sumif doesnt seem to be able to do it.... or maybe its me who cant!


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[JulieD]

Hi Darin

just a IF function for this on
=IF(H1+I1>0,G1/H1+I1,IF(H1+I1=0,"OK","Something else"))

as you've not specified what happens if H1 + I1 is less than 0 i've put the
text "something else" in - which you can change as required. If there's
never any possibility of H1+I1 being less than 0 the formula could be
=IF(H1+I1>0,G1/H1+I1,"OK")

Cheers
JulieD

 

[Darin Kramer]

Thanks Julie!

Works like a charm... appreciate it!!

Just the User limited access sheet and Im out of here




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[JulieD]

you're welcome and thanks for the feedback