#### Combat Womble

##### New Member

- Joined
- Nov 18, 2015

- Messages
- 22

Thank you for the help you have given me over the years - this site is my number excel reference! This time, I just can't figure it out I am trying to get right a small part of what will be a bigger formula.

Can you tell me whats wrong with this: Excel gives me an error message about "

=IF((AND, M2="y", R2<=.26),(L2-1.657+B2)*$V$1*1.25,"TEST")

If M = y AND R = .26 or below then [a bit of math]. If not print test.

I need the principle to work so I can create a big IF formula.

That will look something like

=IF((AND, M1=”y”, R1<=.26),[Math], IF((AND, M1=”y”, (AND, R1>=.261, R1<=.28),[Math], IF((AND, M1="y", R1>=.281),[Math], IF((AND, M1=”n”, R1<=.26),[Math], IF((AND, M1=”n”, (AND, R1>=.261, R1<=.28),[Math], IF((AND, M1="n", R1>=.281),[Math],”ERROR”))))))))))

... but have more permutantions.

y | under.19 | n | under.19 | |

between | between | |||

y | .20 and .23 | n | .20 and .23 | |

y | .23 and .259 | n | .23 and .259 | |

y | .26 and .289 | n | .26 and .289 | |

y | .29 and .319 | n | .29 and .319 | |

y | .32 and .349 | n | .32 and .349 | |

y | .35 and .379 | n | .35 and .379 | |

y | .38 and .409 | n | .38 and .409 | |

y | .41 and .439 | n | .41 and .439 | |

y | over.4 | n | over.4 |

<tbody>

</tbody>

I have about 3.5k lines of data.

Please can you tell me what I've done wrong with the above formula. Also is there an easy way to do this? (intead of writing a very large IF formula)