compute values in multiple choice fields

[visualoomph]

Sample file location: https://www.dropbox.com/s/bqwizti6r7gc6h3/sample%20data%20for%20Chandoo.org.xlsx


If we choose D4 = Inhouse, all existing calculations are applicable. I want to add an additional choice D4=Vendor to show the following values in the column AB (kind of hard coding). Is there any easy way to do this?


8–20 pages = 5 business days

21–30 pages = 12 business days


Appreciate your help.


Thank you

 

[Faseeh]

Hi visualoomph,


Welcome to the forums, can you elaborate the process a bit further, where in column AB do you wantt o show this and what is the criteria? Please explain.


Regards,

 

[visualoomph]

Thank you Faseeh.


If the D4 = In-House, then AB9 =IF(B9>$B$4,1, ((($B9-$B$4)*Variables!$E$3)/6.5))+1


Else, If D4= Vendor then AB8 = X (X is dependent of the values in Column B. Values in B = 8–20 then X = 5, between 21-30 then X=12.

 

[imla]

Hi, I can't see any problem here!

In columns AB put a formula like:

[pre]

=IF($D$4="In-House",$AM9,$AN9)
In AM put a formula like:

[pre][code]=IF(B9>$B$4,1, ((($B9-$B$4)*Variables!$E$3)/6.5))+1

[/pre]
In AN put a formula like:

I need more info in case of (b < 8 or b > 30) what value you want?[/code][/pre]