I haven't been able to find an answer to this because I don't know how to word the search terms. How do I prevent a cell from going above the number 300,000? It is simply the sum of one column subtracted by another but when I haven't completed a set (because I am not to that day yet) it places a result higher than 300,000 and can be confusing.

  • do you have any formula in that cell? – user0 Jan 2 '19 at 6:14
  • Yes, it's just this: =E4-B4 – Mandy R Jan 2 '19 at 6:18
  • E4 currently has the number 500,000 in it and B4 is empty as now. Is it possible to to show an answer not greater than 300,000 until I enter data in B4? – Mandy R Jan 2 '19 at 6:21

solution 1:

=IF(E4-B4<300000; E4-B4; )

solution 2:

=IF(AND(E4<>""; B4<>""); E4-B4; )

  • Solution 2 works. Thank you! Very much – Mandy R Jan 2 '19 at 6:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.