Evaluate Multiple Cells for Formulas

[mpapa01]

Hi all,

Im not new to the forum but been a while since I posted. I have a sheet that is pre-populated with cell formulas. in a different cell i would like to evaluate whether BOTH cells do NOT have formulas. in trying to combine into an IF(AND(NOT(ISFORMULA() it returns an error. any ideas on how to accomplish this? Here is the formula i've tried

Cell A1 = Hardcoded number
Cell A2 = Hardcoded number

Formula in cell A3

= IF(AND(NOT(ISFORMULA(A1,A2)),A1+A2),0)

So stuck on this one. Thanks

 

[admiral100]

Hi,

I think it's a function that exists in Excel 2013 and above ... but I'm not sure about that.
You can simply create a function that checks whether the cell contains a formula:


Function IsFormula(cell_ref As Range)
IsFormula = cell_ref.HasFormula
End Function

 

[mpapa01]

In that case the formula WBD supplied in post#2 works for me.

Ok, but wont work for me. The formula WBD wrote evaluates and returns a true if the cells are formulas (and works just fine if that is want you are looking to do.) I want a True if they are not formulas. WBDs formula is not correct for my purposes.

 

[mpapa01]

Hi,

I think it's a function that exists in Excel 2013 and above ... but I'm not sure about that.
You can simply create a function that checks whether the cell contains a formula:




Function IsFormula(cell_ref As Range)
IsFormula = cell_ref.HasFormula
End Function

Yup definitely a newer function. I was hoping to avoid code because I have a number of other things going on in the sheet and its part of a much larger workbook. Thanks for the code though. I def may need it

 

[admiral100]

Perhaps this :
=if(and(not(isformula(a1)),not(isformula(a2))),"True",a1+a2)

 

[mpapa01]

Perhaps this :
=if(and(not(isformula(a1)),not(isformula(a2))),"True",a1+a2)

Thats It!! Slight tweak and this is the final formula that will work for me

=IF(AND(NOT(ISFORMULA(A1)),NOT(ISFORMULA(A2))),A1+A2)

Replicating the "NOT" function seems to have been tripping me up. Thanks so much!!!