Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if statement involving text
in my project i compare two columns using vlookups and get a number of #N/A.
i am trying to come up with an if statement where if i have #N/A, i want a return of 0, but if not i want the return of the value in another cell in a field called "status". the field "Status" says "open", "closed" or other.i tried general functiosn such as =IF(B3=#N/A,0,H3) where col B contains the result of the vlookup (#N/A or the value i was looking for), and col H contains status in text. the formula i came up with didnt help, returns #N/A. thx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula in pivot tables involving counting text cells | Excel Worksheet Functions | |||
Help with function involving if then else? | Excel Worksheet Functions | |||
Tricky If statement involving dates and text - I'm stumped!!! | Excel Discussion (Misc queries) | |||
Help with a formula involving 3 columns | Excel Worksheet Functions | |||
Computations involving text cells are not working?? | Excel Worksheet Functions |