I have this formula
Please Login or Register to view this content.
I have this formula
Please Login or Register to view this content.
It does not work , do i have an error somewhere ?
And what would you like to do with that?
Note that by putting the 1 within quotes you will be returning a text value, and not a numeric value. Also, you are returning a space character if the expression is FALSE - you probably want the last term to be "".
Hope this helps.
Pete
I only want the formula to give result , for now it gives #NAME?
So I am not sure where I am wrong
Regardless of the 1 being numeric or text
File attached , in case it gives a closer idea
Formula on t2 not working , not sure why
In the middle of the formula yyou have a cell reference just of U and V. Should these not be U2 and V2???
=IF(AND(P2>0,Q2=0,W2>0,U<>1,V<>0),"1"," ")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
the #NAME# error means that the formula is using a name (U and V) that are not defined in the Name Manager (Formulas Tab on the Ribbon). If you click on the error help drop down that should appear in any cell that evaluates to an error, you should be able to click on "help for this error" and find this help file: https://support.office.com/en-us/art...4-199550e0cd70
I suspect that the formula should work once you tell Excel what U and V should point to (I cannot tell what these should refer to).
Originally Posted by shg
Okay now works , was wondering where I wrong , thank you Glenn , MrShorty
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks