Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
This is pretty self-explanatory what I'm doing, but I don't know why I keep
getting a #NAME? error. Please help! I tried various forms of the following formula: =IF(EXACT(A2,A3), AVERAGE(A2:A3), 0) where A2 and A3 contain identical words to test how a function returning TRUE/FALSE would work in an IF statement I have tried setting the logical test to =TRUE, ="TRUE", etc. and keep getting the error. Since the logical test is just something that returns TRUE/FALSE, I do not see why the IF function is having problems digesting it. Can someone explain to me why this doesn't work and how to correct it? (This is not the kind of circumstance where I could use COUNTIF, EXACT, etc., if that's what you would suggest). Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Two TRUE to one FALSE statement | Excel Worksheet Functions | |||
If Statement returns true when false? | Excel Discussion (Misc queries) | |||
Function to return True/False if all are validated as True by ISNU | Excel Worksheet Functions | |||
Want to change the color of a true/false logical statement with i. | Excel Worksheet Functions | |||
How can I make a True or False statement a certain color when usi. | Excel Worksheet Functions |