I have a spreadsheet as follows

Col B can be either F or N

Col J Numbers From 5 TO 36
Col W Numbers from 1 to 100

I want to create a new column based on some complicated frormulae.

If col b is F and col j is less than 5.9, the formula is 2.193*((.99^w1)*(w1^.584))
where w1 is the number in that cell.

If col b is F and col j is between 5.9 and 6.9 the formula is 2.424*((.99^w1)*(w1^.668)) where w1 is the number in that cell

If col b is F and col j is between 6.9 and 7.5, the formula is 2.79*((.99^w1)*(w1^.612))where w1 is the number in that cell

If col b is F and col j is between 7.5 and 8.5, the formula is 3.052*((.99^w1)*(w1^.654))where w1 is the number in that cell

If col b is F and col j is between 8.5 and 11.9, the formula is 3.445*((.99^w1)*(w1^.665)where w1 is the number in that cell

If col b is F and col j is between 11.9 and 12.5 the formula is 4.942*((1.004^w1)*(w1^.494))where w1 is the number in that cell

If col b is F and col j is between12.5 and 14.5 , the formula is 3.641*((.99^w1)*(w1^.772))where w1 is the number in that cell

If col b is F and col j is greater than 14.5 , the formula is 3.853*((.984^w1)*(w1^.856))where w1 is the number in that cell

If col b is N and col j is ANY VALUE , the formula is 8.017*((.9832^w1)*(w1^.7566))where w1 is the number in that cell


i presume to do this I will need IF and AND functions,but I cant get to do it.