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.