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 specific use for this spreadsheet I am trying to develop. Column O has two different options to get the amount in each line. One type of number is based on the formula above using column N times the Original  (K) – 25, times column N + 30. The other type of number is just a base number entered by user i.e. 25, 30, 32 etc. I need to have it so the user enters a number in column “K” and either a number in column “N” or a “base number in column “O”. to determine if column “O” uses the formula or not. The user will not see the formula, but it will be changeable. The crux of the matter is: I want to give a user the form below in Excel. No formulas visible. They will enter numbers in line items in columns “K” and “N”. When they enter in “N”, the formula will apply to line item in column “O”. Otherwise, they can just enter a number in “O”. I can do this if I just do one line item at a time, but I can’t get a formula to do it referring to column i.e. N:N example I’ve tried O=(IFNUMBER (N:N), =(K693-25)*N693+30. I know that’s not right, but how can I accomplish this. I love Excel, but I am just not that good at it ……. yet (I am 80 years old….LOL). Thank you so much for any help! I am running out of time to accomplish this!

Sincerely, Mel Lange

|          K      |      L         |      M       |       N           |         O             |

KILOGRAMPAY PER KILOPAIDORIGINALMORETOTAL  34.85 35$1.25$42.3134.94 35$1.25$42.4334.57 35$1.25$41.9634.67 35$1.25$42.0915.70 16$1.25$25.0043.69 44$1.25$53.3692.13 92$1.25$113.9115.70 16 $25.0015.70 16 $25.00     15.70 16 $25.0015.70 16 $25.0015.70 16 $25.0015.70 16 $25.0015.70 16 $25.0015.70 16 $25.0027.401542$1.25$33.0027.241542$1.25$32.8015.70 16 $25.0015.70 16 $25.0015.70 16 $25.0015.70   $25.0015.70 16 $25.0015.70 16 $25.00564.9930579 $776.86

​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 specific use for this spreadsheet I am trying to develop. Column O has two different options to get the amount in each line. One type of number is based on the formula above using column N times the Original  (K) – 25, times column N + 30. The other type of number is just a base number entered by user i.e. 25, 30, 32 etc. I need to have it so the user enters a number in column “K” and either a number in column “N” or a “base number in column “O”. to determine if column “O” uses the formula or not. The user will not see the formula, but it will be changeable. The crux of the matter is: I want to give a user the form below in Excel. No formulas visible. They will enter numbers in line items in columns “K” and “N”. When they enter in “N”, the formula will apply to line item in column “O”. Otherwise, they can just enter a number in “O”. I can do this if I just do one line item at a time, but I can’t get a formula to do it referring to column i.e. N:N example I’ve tried O=(IFNUMBER (N:N), =(K693-25)*N693+30. I know that’s not right, but how can I accomplish this. I love Excel, but I am just not that good at it ……. yet (I am 80 years old….LOL). Thank you so much for any help! I am running out of time to accomplish this!Sincerely, Mel Lange|          K      |      L         |      M       |       N           |         O             |KILOGRAMPAY PER KILOPAIDORIGINALMORETOTAL  34.85 35$1.25$42.3134.94 35$1.25$42.4334.57 35$1.25$41.9634.67 35$1.25$42.0915.70 16$1.25$25.0043.69 44$1.25$53.3692.13 92$1.25$113.9115.70 16 $25.0015.70 16 $25.00     15.70 16 $25.0015.70 16 $25.0015.70 16 $25.0015.70 16 $25.0015.70 16 $25.0015.70 16 $25.0027.401542$1.25$33.0027.241542$1.25$32.8015.70 16 $25.0015.70 16 $25.0015.70 16 $25.0015.70   $25.0015.70 16 $25.0015.70 16 $25.00564.9930579 $776.86  Read More

​