LinkBack URL
About LinkBacks
Hi please take a look below:
I have the following formula:
The code only works for the first part of the formula.
Please Login or Register to view this content.
Please see attached workbook for example.
Hi please take a look below:
I have the following formula:
The code only works for the first part of the formula.Please Login or Register to view this content.
Please see attached workbook for example.
Can you state your expected result?
Your dropdown does not work for me and then there is a link to extral workbook in your Named Manager.
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
the drop down list contains:
< $1.0m potential P&L impact
> $1.0m potential P&L impact
Expected result should be that cell shades when drop down value of > $1.0m potential P&L impact is selected and an integer of less 1 million is input. Alternatively if < $1.0m potential P&L impact is selected from the drop down and an integer of greater than 1 million is input then the cell should also shade in the scenario.
the drop down list contains:
< $1.0m potential P&L impact
> $1.0m potential P&L impact
Expected result should be that cell shades when drop down value of > $1.0m potential P&L impact is selected and an integer of less 1 million is input. Alternatively if < $1.0m potential P&L impact is selected from the drop down and an integer of greater than 1 million is input then the cell should also shade in the scenario.
don't see a link between your formula & the question, but this does what you want in post # 3:
=AND(OR(C5=$C$15,C5=$C$16),D5<$C$17)
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Apologies if i was unclear. I need the formula to work down the column not just for one line hence why I need to use the COUNTIF formula.Originally Posted by benishiryo
Hi all
My apologies if am not quite sure how much more clearer I can explain my issue.
I have attached another workbook which sets out 3 scenarios in separate TABS.
Scenario 1 and 2 the formula works.
The 3rd scenario explains the issue and explains what my expected result should be.
Thank you for your patience all.
PS just updated the workbook as i noticed a few careless mistakes in my example. Should make sense now.
Last edited by Mountain99; 09-16-2013 at 06:58 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks