It was IS TEXT. Thanks David...

Now I need help with writing this.

I have
Subtotal (O27)
Shipping (O28)
Sales Tax (029)
Total (O30)

The Shipping cell will result in either a calculation or "NO COST" text
statement depending on the STATE shipping location. The following formula is
currently in the Shipping cell

=IF(H14="","---",IF(OR(H14="ID",H14="OR"),"NO
COST",IF(H14="NV",O27*0.6,IF(H14="CA",O27*0.9))))

I now need assistance writing an ISTEXT formula in the TOTAL cell and also
the sum of O27+O28+O29

Thanks for the help.

"David Biddulph" wrote:

Perhaps they intended to say ISTEXT, not ISTEST?
--
David Biddulph

"Sondra" wrote in message
...
HELP!!

I'm working on a project for my class and they want me to "test whether
there is a value in a cell in order to sum it up"

Add Invoice total + Shipping Cost + Sales Tax.

However, the Shipping Cost Cell has been set up as follows:

=IF(H14="","---",IF(OR(H14="ID",H14="OR"),"NO
COST",IF(H14="NV",O27*0.6,IF(H14="CA",O27*0.9))))

So if there is "NO COST" in the Shipping Cost cell the simple summation
formula won't work. They want us to do ISTEST, but I can't find any
information on this. I am beginning to think its a typo.

Any advice would be great!