Selecting if formulas based on column value
Hello,
I am trying to have multiple formulas used for different values entered.
I have a dropdown list column with the values of "AB" and "ON" in F14.
A user will enter a numeric value in E14 and I want it so that if E14 ONLY has the value of 1 or 2 the following formula will execute in G14
=IF(F14="AB",D14/1.04*0.04/2,IF(F14="ON",D14/1.12*0.12/2))
OR if E14 equals 3 then I want =IF(F14="AB", D14/1.04*0.04/2,IF(F14="ON",D14/1.12*0.12/2))
if(or(E14=1,E14=2),IF(F14="AB",D14/1.04*0.04/2,IF(F14="ON",D14/1.12*0.12/2)),if(E14=3,IF(F14="AB", D14/1.04*0.04/2,IF(F14="ON",D14/1.12*0.12/2)),"")
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
I dont really see any difference between the 2 formulas?
<3=IF(F14="AB",D14/1.04*0.04/2,IF(F14="ON",D14/1.12*0.12/2))
3 =IF(F14="AB",D14/1.04*0.04/2,IF(F14="ON",D14/1.12*0.12/2))
The suggestion in #2 could also be shortened to...
if(E14<3,IF(F14="AB",D14/1.04*0.04/2,IF(F14="ON",D14/1.12*0.12/2)),if(E14=3,IF(F14="AB", D14/1.04*0.04/2,IF(F14="ON",D14/1.12*0.12/2)),"")
Again though, I dont see the difference?
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
Thank you it works!
Happy to help and thanks fior the feedback
Still curious about what the difference is supposed to be (and which formula you ended up using?)
I used your formula. The two formulas are the same just need to execute them when a certain value is entered.Originally Posted by FDibbins
Happy to help and thanks fior the feedback
Still curious about what the difference is supposed to be (and which formula you ended up using?)
Thanks!
If the 2 formulas are the same, why even do the test in the 1st place?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks