| 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! |
| 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 | |||
Threaded Mode
