| Home |
| Search |
| Today's Posts |
|
#6
|
|||
|
|||
Worked like a charm. Thanks so much.
"N Harkawat" wrote: Simply put a -- (double negative) in front of your formula to look like this --IF($A1="Network", AND(ISNUMBER(FIND("h",$B3)))) becasue --(True) is equal to 1 and --False = 0 "pomalley" wrote in message ... I'm using the following function in cell C3: =IF($A1="Network", AND(ISNUMBER(FIND("h",$B3)))) The result in C3 is TRUE. If the value in A1 = network and the value in B3 is "h", give me the number 1 in cell C3 instead of TRUE. If the result is FALSE, I'd like the cell to be blank. Any ideas are greatly appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
| How do i convert a number of seconds to a date/time? | Excel Worksheet Functions | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
| Convert week number into calendar month? | Excel Worksheet Functions | |||
| How do I convert 300616a to show as a number 303616? | Excel Worksheet Functions | |||
Threaded Mode
