I have a cell in a row that is either a directly entered number, or a SUM() of some other cells. Is there any function I can use in a different cell to know if the value in the former cell was directly entered or the result of a formula?

  • If the cells summed are consistent, you could some them somewhere else (perhaps hidden or otherwise out of view) then you could compare the values. – Tyson Nov 4 '15 at 2:35
  • I am unaware of any such function even with Excel. Are you looking for conditional formatting based on a particular cell? – bjbk Nov 4 '15 at 4:06
  • Summed cells are not consistent. Not conditionally formatting; just looking to do a different formula in ANOTHER cell based on whether the first cell is a formula vs. number. – jaydisc Nov 4 '15 at 6:30
  • 1
    Just out of curiosity, how do you plan on using this feature? Maybe there's another method. – Arc676 Nov 4 '15 at 8:29

You must log in to answer this question.

Browse other questions tagged .