=IF(B4="X",0,IF(C4="X",50,IF(D4="X",125,200)))

Dave
--
Brevity is the soul of wit.


"StephanieH" wrote:

I know I'm making this harder than it realy is, but right now I'm stuck. I
need a formula that will perform the following:
IF B4 = X then display "0"
IF C4 = X then display "50"
IF D4 = X then display "125"
IF E4 = X then display "200"

Any help would be appreciated.