=IF(B34="x",E34=(E33*1.01),0)....this is what i typed into cell E34. I want it to look at cell B34, and if it contains the letter x, put the result of (E33*1.01) into cell E34. if cell B34 does not contain and x it should put a 0 in cell E34. please help. Why won't this work?
Thank you,
Ralph R.
Your syntax is wrong. Try this:
=IF(B34="x",E33*1.01,0)
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
=IF(L6<0 AND(m6>5) AND(o5<0) AND(p6>5) AND(s6>3)),L25,0)....Glenn you rock!
Can you assess this one please?
I want this cell to apply the greater than/less than logic above and if all criteria are met make this cell = what is in cell L25, else make this cell 0.
Thank you....
Ralph R.
Hi and welcome to the forum
You should use the "insert function (fn to the left of the formula bar) to help you with the function syntax, it really helps
=IF(L6<0 AND(m6>5) AND(o5<0) AND(p6>5) AND(s6>3)),L25,0)
=IF(AND(L6<0,m6>5,o5<0,p6>5,s6>3),L25,0)
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
Thanks Ford. I'd slipped away for a nice cool beer and you beat me to it!
what, and you didnt bring 1 back for me??? lol
Sure. Here it is... just reach out.... 3000 miles. I'm just off the eastern coast of the USA.
S'ok, give it to my daughter, she is in Luton
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks