Hi all,
I am trying this formula in excel, but for some reason its showing value error for text values. Dont know why
=IF(AND(K35="No Position",K35="PRICE MISSING"),0,(E35*K35)/AD35).
It works fine if i have number in column K, but if there is above mentioned text in formula, it shows error.
Kindly help.
It shows an error because you cannot multiply a number by a text value.
Also this part
AND(K35="No Position",K35="PRICE MISSING")
Will always return False, because K35 cannot be both "No Position" and "PRICE MISSING"
Should the formula be
=IF(OR(K35="No Position",K35="PRICE MISSING"),0,(E35*K35)/AD35).
K35 cannot equal "No Position" AND equal "PRICE MISSING", just not possible. You might want
=IF(OR(K35="No Position",K35="PRICE MISSING"),0,IF(ISNUMBER(K35),E35*K35/AD35,0)).
Your formula is mutiplying K35 by E35. If K35 contains ANY text then the formula will result in a #VALUE!. hence there's no point in defining two particular strings. Instead just use
Formula:
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks