Hey group, have a question for you. I currently have a working formula that reads =IF(H30>0,"RIGHT: "&H30&"'","LEFT: "&ABS(H30)&"'"). This does exactly what I want it to do except for if H30=0. If H30=0, I want it to say "On Line".
Can someone please help. I've been working on this for a week!
Thanks
Perhaps
=IF(H3=0,"On line",IF(H30>0,"RIGHT: "&H30&"'","LEFT: "&ABS(H30)&"'"))
No that doesn't work. It makes every value "On Line". Thanks for the trying however.Originally Posted by Pepe Le Mokko
It does work. However, Pepe did make a small typo which maybe you didn't spot...
=IF(H30=0,"On Line",IF(H30>0,"RIGHT: "&H30&"'","LEFT: "&ABS(H30)&"'"))
=IF(H30 nor =IF(H3....
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.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
??????????
=if(h30... Not =if(h3..
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Row\Col LEFT: 1' I30: =IF(H30 = 0, "On line", IF(H30>0,"RIGHT: " & H30 & "'", "LEFT: " & ABS(H30) & "'")) On line RIGHT: 1' Left: 1' I33: =LOOKUP(SIGN(H33), {-1,0,1}, {"Left:","On Line","Right:"}) & TEXT(H33, " 0'; 0';") On Line Right: 1'
Entia non sunt multiplicanda sine necessitate
Got it! Sorry, I work with numbers all day and they ran together on me. I didn't notice the typo and then the "nor" confused me even more. I was like "I didn't know there was a "nor" function." LOL Thank you both very much!!! Life Savers!!!
Glen means that Pepe referenced H3 in the 1st IF statement, it should have been H30
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Ha Ha. I point out one typo and then make one of my own. That's what happens when you have 5 thumbs on each hand....
Last edited by Glenn Kennedy; 11-22-2014 at 03:19 PM. Reason: I made another typo
you mean, like that?
LOL
That's what happens when you grow old ....
tell me about it
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks