I can use some assistance in writing a formula that looks at column A and if column A is populated with a "YES" then looks to the amount in column B and returns the greater of 2% of the amount in column B or $25 in column C. If Column A is not populated with a "YES" then column C should remain blank. Thank you very much for your consideration.
Try this, asuming data start in a2...
=IF(A2="Yes",MAX(0.02*B2,25),"")
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
Much obliged and have a great weekend
Shall do. thanks for the Rep.
If you are so inclined I have another and a bit more challenging one to run past you. If you are agreeable I will send you the particulars. Thanks
Sounds like this might be a new question from the answer given in post #2. Please create a new thread with your new question.
HTH
Regards, Jeff
Yep. Start a new post. I'm in SE Asia and will look out for it in the morning, if it hasn't been answered by then.
Thanks for your willingness to assist
You're welcome. However, I've downed a few Chang beers now and, consequently, any reply from me for the next few hours wouldn't be right!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks