Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ISTEST Function
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ISTEST Function
Hi,
I've never heard of ISTEST and I don't understand the question. SUM is clever enough to ignore text in the range so if one of the cells you are summing contains the text NO COST it will be ignored. Perhaps you need to clarify. Mike "Sondra" wrote: 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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ISTEST Function
Ah,
You may mean an IS Test. i.e =IF(ISNUMBER(A1),"Yes","no") Mike "Mike H" wrote: Hi, I've never heard of ISTEST and I don't understand the question. SUM is clever enough to ignore text in the range so if one of the cells you are summing contains the text NO COST it will be ignored. Perhaps you need to clarify. Mike "Sondra" wrote: 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! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ISTEST Function
Sondra wrote...
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" .... . . . They want us to do ISTEST, but I can't find any information on this. *I am beginning to think its a typo. .... Best course of action would be to ask the instructor whether ISTEST is a typo or whether it's a placeholder for a function which Excel does provide. Your instructor may want you to check the value type, but in the real world if *expected* results were either text or number and all you need to do sum it, you wouldn't check value types. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ISTEST Function
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! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ISTEST Function
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! |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ISTEST Function
Sondra wrote...
It was IS TEXT. *Thanks David... Now I need help with writing this. .... Is this or isn't it *YOUR* homework? How much of *YOUR* homework are you allowed to let other people do for you? |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ISTEST Function
Harlan:
This is an assignment for my course. The instructor informed us to use all resources to find the answers. I'm 45 years old and I figure that the "experts" are the best resources to use. "Harlan Grove" wrote: Sondra wrote... It was IS TEXT. Thanks David... Now I need help with writing this. .... Is this or isn't it *YOUR* homework? How much of *YOUR* homework are you allowed to let other people do for you? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ISBLANK function not working when cell is blank dut to function re | Excel Discussion (Misc queries) | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions |