You formula and the accompaning description don't make sense.

1. First, can only one cellin the range B1:B3 contain X?
2. You say add in a formula if it is blank - if what is blank? what is "it"
3. Is X a range name or a text entry?
4. by Value=0 do you mean that if B1=X then return 0? If so what do you
want to do if B1:b3 ALL = x - SUM them Average them, take the largest result?

In general a formula might look like:

=IF(B1="X",0,IF(B2="X",5,IF(B3="X",10,"")))


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"C Kreig" wrote:

I would like to get a formula
=IF((B1=X),(Value=0),IF(B2=X,(Value=5),IF(B3=X,(Va lue=10)))
I keep getting an error telling me that I am missing a parenthesis.

I would also like to add in the fomula that if it is blank do not calculate
the value.

Thank you in advance for your help.