Hi,

Currently I am using this formula:

=IF('Raw Data Sheet'!V6=0,"Spot Cost",'Raw Data Sheet'!V6*100)

Which returns 'Spot Cost' if the value of V6 on the raw data sheet is zero
or a multiple of 100 if it is greater than zero. This is fine.

The problem I have however, is when the value of 'V6' is blank (i.e. just a
space or no data entered) my return from the formula is '#VALUE!' and I need
to create a caveat within the formula to cover it. For example, if the value
of V6 is blank then ideally I would like a return of 'Spot Cost'.

How would I go about doing this? Any help would be really really appreciated.

Kind regards,

Ed.

=IF(OR('Raw Data Sheet'!V6=0,'Raw Data Sheet'!
V6=""),"Spot Cost",'Raw Data Sheet'!V6*100)

HTH
Jason
Atlanta, GA

-----Original Message-----
Hi,

Currently I am using this formula:

=IF('Raw Data Sheet'!V6=0,"Spot Cost",'Raw Data Sheet'!
V6*100)

Which returns 'Spot Cost' if the value of V6 on the raw
data sheet is zero
or a multiple of 100 if it is greater than zero. This is
fine.

The problem I have however, is when the value of 'V6' is
blank (i.e. just a
space or no data entered) my return from the formula
is '#VALUE!' and I need
to create a caveat within the formula to cover it. For
example, if the value
of V6 is blank then ideally I would like a return
of 'Spot Cost'.

How would I go about doing this? Any help would be
really really appreciated.

Kind regards,

Ed.
.

Thanks - much appreciated.

"Jason Morin" wrote:

=IF(OR('Raw Data Sheet'!V6=0,'Raw Data Sheet'!
V6=""),"Spot Cost",'Raw Data Sheet'!V6*100)

HTH
Jason
Atlanta, GA

-----Original Message-----
Hi,

Currently I am using this formula:

=IF('Raw Data Sheet'!V6=0,"Spot Cost",'Raw Data Sheet'!
V6*100)

Which returns 'Spot Cost' if the value of V6 on the raw
data sheet is zero
or a multiple of 100 if it is greater than zero. This is
fine.

The problem I have however, is when the value of 'V6' is
blank (i.e. just a
space or no data entered) my return from the formula
is '#VALUE!' and I need
to create a caveat within the formula to cover it. For
example, if the value
of V6 is blank then ideally I would like a return
of 'Spot Cost'.

How would I go about doing this? Any help would be
really really appreciated.

Kind regards,

Ed.
.