Return a value when value is something (VBA, complex formulas may be required)

[jasonleewkd]

Hi all, I would love for some assistance. I'm not sure if vba must be required or a bunch of formulas is required. This really escapes me so I have no leads. Unlike my usual self which I'll investigate thoroughly. File can be found here http://bit.ly/14aSG9A.


Thank you all!

 

[sdsurzh]

Hi,


Can you paste the below formula in I6. I guess you looking for this.


=IF(B2=4000,IF(B9=3%,C12))


Thanks,

SK

 

[jasonleewkd]

Hi Suresh, is there a dynamic formula so that when I drag it to the right it will auto fill?

 

[sdsurzh]

Sorry Jason,


Try this


=IF($B$2=4000,IF($B$9=3%,C12),"")


Thanks,

SK

 

[jasonleewkd]

It's returning a nil value now. Is there a formula that will return the value in C12 dynamically based on the values in both I2:Y2 for a specified value between G3:G6?

 

[jasonleewkd]

Closed