SIMPLE Excel Formula Problem

[cappinthepigs]

Hey guys, new to this part of the forum, but heard this is definetly the place to go for questions like this.

This will probably be a simple question for most of you, but I have NO CLUE how to do this.

I have a spreadsheet for tracking purposes of my own bets, done myself that's why it sucks so badly! But I have fields for Team A Score, Team B Score, O/U #, and a O/U Result field.

In the result field I have this formula =IF((K3>G3),"OVER","Under") that tells me if the game went over or under.... How do I make it show a push is my only question.

Thank You many times for any help!

Cappin

[rfr3sh]

techonthenet.com/excel/formulas/if_nested.php

[Rod_M]

=if(k3=g3,"push",if(k3>g3,"over","under" ))

[Emily_Haines]

...........

[cappinthepigs]

techonthenet.com/excel/formulas/if_nested.php

Many Thanks! I learned something there!

[cappinthepigs]

=if(k3=g3,"push",if(k3>g3,"over","under" ))

Thank You as well Rod!

I'm really trying to figure all this stuff out, could be quite handy!

If I post what I'm using will yall look at it and see if it's retarded or not?

Anybody that wants can steal this piece of crap too! LOL

[cappinthepigs]

Just started doing this so I THINK I'm on the right track, but I'm learning everything as I go.

[uva3021]

Looks good, i hope you don't mind but I felt compelled to make a few changes and you cann use it if you want to, just enter the score and units wagered, everything else is automated

when i saved it said some features may be incompatible with excel 2003, not sure if you have that version or not, i assume you do since it asked me

it should be ok though, all i did was use "IF(AND...."