Help with formula...if I knew how to correctly word it, I may already know how to fix it

[ywoodz]

Example: =sum('Home/Away'!D5/'Home/Away'!G25*(-100))

This gives me a number. I need to add to this and I am not sure how... I need this to calculate... but then I also need a "if that answer is > than 100, then add 200 to the answer.
Any help is very much appreciated! I am sure it is something simple but I am not at all proficient. Also, please be patient if I need to 'vote' or give +1 to help you gotta hold my hand through it. Thanks everyone

 

[Beyond_avarice]

=IF((HomeAway!D5/HomeAway!D25*(-100))>100,(Home!D5/Home!D25*(-100))+200,(Home!D5/Home!D25*(-100)))

Not sure how you are pulling off the "/" in your Sheet name(not allowed). I suspect you typed it in this post and got carried away.

 

[johnmpl]

You can try too:

=-HomeAway!D5/HomeAway!G25% + 200 * (-HomeAway!D5/HomeAway!G25%>100)

Blessings!

 

[ywoodz]

Thank you!!! I get away with it because of google docs... please don't hate me.
This ended up being exactly what I needed: =IF(('Home/Away'!D5/'Home/Away'!G25*(-100))>-100,('Home/Away'!D5/'Home/Away'!G25*(-100))+100,('Home/Away'!D5/'Home/Away'!D25*(-100)))