=if($D$99=1960,if($D$7='Proficy CL Limits,
Ranges"!$G$7,1,0),if($D$99=311,if($D$7='Proficy CL Limits,
Ranges"!$D$7,1,0),if($D$99=305,if($D$7='Proficy CL Limits,
Ranges"!$J$7,1,0),"otherwise")))

" wrote:

hi,

i need some help with a complex excel function that may need to be a
macro but i am not the most proficent at them. what i need is below if
anyone can offer help

i need to check the data in D99 and then run a specific formula
depending on the data in D99

if d99 = 1960 then the forumula needs to be =IF(D7='Proficy CL Limits,
Ranges'!G7,1,0)

if d99 = 311 then the formula needs to be =IF(D7='Proficy CL Limits,
Ranges'!D7,1,0)

if d99 = 305 then the formula needs to be =IF(D7='Proficy CL Limits,
Ranges'!J7,1,0)

the formula must then run in d100 to d184

Any help would be greatly appreciated