Want to highlight a helpful answer? Upvote!
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
I am trying to create a table in which the total calculated is as follows: 40 for 0 items, 100 for 1 item, and 50 for each additional item beyond the first one. Suggestions?
| Items | Total |
|---|---|
| 0 | 40 |
| 1 | 100 |
| 2 | 150 |
B1=IF(A1=0, 40, IF(A1>0, 50×(A1+1), "No Negative Numbers"))
this is shorthand for... select cell B1, then type (or copy and paste from here) the formula:
=IF(A1=0, 40, IF(A1>0, 50×(A1+1), "No Negative Numbers"))
select cell B1, copy
select cells B1 thru B5, paste
nlimthong,
As this is the second time you have asked this same exact question in five days, and it was answered in your previous posting, is there something that we are missing? It looks like the previous poatings asnwer didnt solve your issue, and Wayne is basically giving you the same thing again.
If we need to clarify or expand on our answers please let us know so we can get an answer that satisfies what you are trying to accomplish.
thanks
jason
I thought I had answered but couldn't find that post....
I agree, please let us know if there is something we are missing.
create a formula in numbers
