| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
if Function problem
I am trying to make sure that the row, that meets two criteria return true and then multiply by a percentage. =IF(AND(SEARCH("*Total",C5),F6<" "),F6*0.03," ") this returns a VALUE error. what am i doing wrong, can i not use the search funtion within an IF AND stmt thanks Jerry |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count function problem | Excel Worksheet Functions | |||
| Lookup function problem (kg) | Excel Worksheet Functions | |||
| Problem with function "Worksheet_Change" | Excel Worksheet Functions | |||
| Problem adding a range using Sumif function. | Excel Worksheet Functions | |||
| Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions | |||
Threaded Mode
