Hi guys
Can anyone help me write an IF OR formula please?
I am getting an error message/return of 0.
I want to write if N2 or R2 is greater than 99.99, return Yes, otherwise return No
Thank you!
Hi guys
Can anyone help me write an IF OR formula please?
I am getting an error message/return of 0.
I want to write if N2 or R2 is greater than 99.99, return Yes, otherwise return No
Thank you!
Last edited by rayted; 07-22-2019 at 09:13 AM.
Thanks,
R.
Hi rayted,
Try:
=IF(OR(N2>99.99,R2>99.99),"Yes","No")
Hope this helps.
Snook
Hi,
Please Login or Register to view this content.
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
Administrative Note:
We would very much like to help you with your query, however the thread title does not really convey what your request is about.
Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).
Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.
(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
=IF(OR(N2>99.99,R2>99.99); "Yes","No")
Best Regards,
Maras.
You got THREE answers
Hi guys,
Uploading my sheet.
Please see CELL S2 which is where I want to input the formula but it's not working?
thank you!
Hi Keebellah sadly with no success :-(
UPDATE
=IF(OR(IFERROR(N2,0)>99.99,IFERROR(R2,0)>99.99),"Yes","No") is not working... I keep seeing 0
Last edited by rayted; 07-22-2019 at 09:55 AM.
Well, you see the message, you cannot have Q2 look at S2 for a value, it's called circular reference
And R2 the same. NO GO THAT WAY
Read about it Circular references
ok i am trying different alternatives and moving columns around with no luck!
Last edited by AliGW; 07-22-2019 at 10:58 AM. Reason: Please don’t quote unnecessarily.
Very simple. Circular references are not allowed. We all have no idea what you want to achieve but I guess you'll have to add 'helper' columns, but syill, if different formula's are dependent of formulas on cells you need another formula, well, won't work
I hv a problem. I am running a call center with 15 agents. I want a if function formula to find agent late based on login time. I hv three shift, morning star from 8:30:00AM, AFTERNOONS start from 2:30:00PM, night start from 10:00:00PM. Now give me a formula to find the agent presence based on login time. Suppose Mr.x has morning shift and logged at 8:35AM. Now if I put this information in cell, then how excel will give auto presence indicators in another cell
Administrative Note:
Welcome to the forum.
We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.
Please see Forum Rule #4 about hijacking and start a new thread for your query.
If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks