I think its a nested IF?

[Jimmy110]

Hi all,

hoping someone can help me with the correct IF formula???

Basically, C9 is the average of my measurement readings, E9 is a dynamic target that instructs the user what the next measurement should be to pull the average back towards the target.

So if I have a target of 15, and C9 is displaying the average of all the readings so far.... what I'm trying to do is the further away from the target C9 is, the greater the correction would be in the "Dynamic Target" cell which is E9.

I guess explained verbally, it would sound like this;

If Cell C9 is between 15 and 15.05 then Cell E9 would return 15. However if Cell C9 is between 15.05 and 15.15, Cell E9 would return 14.9. Also if C9 is more than 15.15, E9 would return 14.7.

Then the same the opposite way....if C9 was between 14.9 and 15, E9 would return 15.1 and if C9 is less than 14.9, E9 would return 15.3.

I just need some help to make that a formula lol

thanks

James

 

[igold]

This in Cell E9:

=IF(AND(C9>=15,C9<=15.05),15,IF(AND(C9>=15.05,C9<=15.15),14.9,IF(C9>15.15,14.7,IF(AND(C9>=14.9,C9<=15),15.1,IF(C9<14.9,15.3,)))))

 

[Jimmy110]

This in Cell E9:

=IF(AND(C9>=15,C9<=15.05),15,IF(AND(C9>=15.05,C9<=15.15),14.9,IF(C9>15.15,14.7,IF(AND(C9>=14.9,C9<=15),15.1,IF(C9<14.9,15.3,)))))

Thank you so much igold.....you have saved me soooo much time and heartache lol

 

[igold]

You are welcome, I was happy to help. Thanks for the feedback!