IF, OR Function Help!!!

[martyloo]

I have the following formula:

=IF(OR($B$8>'Working Strategy'!$P$3,$D$22>=18),"STAND",IF('Main Console'!$B$8<='Working Strategy'!$P$3,"HIT"))

This always displays "HIT" in the cell the formula is written in, is there anyway i can keep the cell blank untill some data is written in to trigger hit or stand?

before I start plugging in data
cell B8 displays nothing its a blank cell with an IF formula in it only triggered when certain data is plugged into another cell
cell P3 displays nothing its a blank cell with an IF formula in it only triggered when certain data is plugged into another cell
cell D22 displays 0

I want it to only say "HIT" when the numbers in B8 are greater than the numbers in P3

 

[jlatendre]

Hello, maybe I am confused with what you need but I have come up with this, see if it helps, (im unsure when you would like it to display stand)

=IF($B$8>$P$3,"HIT"," ")

Jesse