Help with comparing several columns and outputting a different result depending on column

Hey all,

I dont know if my heading makes sense at all but this is what I am trying/failing to accomplish...

I have 5 columns that I want excel to check and then output a number based on the selection. The criteria in the 5 columns that I need is only that it is populated by something....

Like this...

A_____B_____C_____D_____E_____Result
x______________________________1.25
______x_________________________1
______x_________________________1
___________________x____________.5

Etc.....

So the cell in the column could be anything.. an X or a 1 or anything.... So what I would like it to do is go... is A populated if yes output 1.25.... is B populated if yes output 1.... etc... but if 2 fields are X'd then it errors

Any help is much appreciated!