Notifications
Clear all
General Excel Questions & Answers
3
Posts
2
Users
0
Reactions
61
Views
Topic starter
HI
I want to use IF function e.g. =IF(ISNUMBER(SEARCH("Price",H54)), "=RIGHT(H54,6)*1"," =(H54)*1")
Instead of TRUE FALSE text I want to run the formula starting of "=" e.g. =RIGHT(H54,6)*1 & "=(H54)*1" but the above IF formula write as text.
is there any alternate formula to implement the logic.
Thanx and regards
Posted : 01/09/2022 4:22 am
Hi Mukesh,
Because you're enclosing the results you want in "", you are treating everything between the "" as text. To get the function to work remove the "" e.g.
=IF(ISNUMBER(SEARCH("Price",H54)), RIGHT(H54,6)*1 , H54*1)
Regards
Phil
Posted : 01/09/2022 4:32 am
Topic starter
BIG BIG THANKS, I TRIED EVERYTHING EVEN WITHOUT INVERTED COMMAS BUT NOTHING WORKED AS MY MISTAKE WAS EQUAL TO SIGN = IN MY FORMULA.
THANKS A LOT....
Posted : 01/09/2022 6:31 am
