Forum Discussion
I need help with my excel file. Nested If statements
I didn't find where do you use this formula, but in any case it's incorrect. It could be
=IF(@Pay_Num<>"", IF(F18<1000,F18*$L$4,F18*$L$5) ,"")Pay_Num is the range, better to use cell reference in the formula.
Plus you have circular references in your file, better to find and remove.
thank you for the response. It helped me out one little step, but the excel file still isn't doing what I really want it to do yet.
look at this picture...
I want the cells in the J column to grow or shrink in number of rows in accordance with the A column
Does that make sense? Like if the Loan term is 24 payments (for 2 years).. I don't want J column to show 330 rows. I want it to show 24 rows in accordance with the A column!
Make sense?
SergeiBaklan Thank you for the help though. It's getting there. I'm just not sure how to describe this better and i'm unsure of how to make excel automate this;. view the screenshot