Forum Discussion
Formula help in excel spreadsheet
I need help with inserting a formula into a spreadsheet I have. Let me explain the criteria. Column "O" (PAID) uses this formula; O693=(K693-25)*N693+30. Works great! My problem ..... I have a speci...
If i understand you correctly you want column O to either be calculated OR be user entered but that doesn't work well. I recommend instead have another column for user entry and if they enter a number in that column then col O will use that but if not then it will calculate based on K and N or it could be the other way around if there is a number in N then use K and N but if not then use that new column. and if nothing in either the new column or N then leave blank. so something like:
O=IF(N693<>"", (K693-25)*N693+30, [new column] )
or applied as a dynamic array
=IF(N6:N693<>"", (K6:K693-25)*N6:N693+30, [new column range 6:693] )
O=IF(N693<>"", (K693-25)*N693+30, [new column] )
or applied as a dynamic array
=IF(N6:N693<>"", (K6:K693-25)*N6:N693+30, [new column range 6:693] )
m_tarler, Thank you for your help! You were right about adding a column. The formula works fine i.e. =IF(O669<>"", (K669-25)*O669+30, N669)
I can't get they array to work but this is a large "weekly" workbook for a year's records (52 weeks)) so I have to work on that. has text at the beginning of each week.
Thanks again .......
I can't get they array to work but this is a large "weekly" workbook for a year's records (52 weeks)) so I have to work on that. has text at the beginning of each week.
Thanks again .......