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

 

[wideboydixon]

=if(or(isformula(a1),isformula(a2)),0,a1+a2)

?

Wbd

 

[Gerald Higgins]

As far as I know there is no ISFORMULA function.

 

[mpapa01]

=if(or(isformula(a1),isformula(a2)),0,a1+a2)

?

Wbd

Thanks for your reply however, that will evaluate to a True statement if either one is hardcoded. I need for the statement to only be True if both are hardcoded. Thanks for trying

 

[mpapa01]

Perhaps it depends on the version of Excel you are using. In my version there is. Thanks

 

[Fluff]

Try changing the or to and in WBD' suggestion

 

[mpapa01]

Try changing the or to and in WBD' suggestion

Thanks for your reply. substituting AND works if I wanted a true statement if they are both formulas. What i need is a true statement if they are both NOT formulas. So i need to insert AND and NOT somewhere in the formula string and that is when it breaks on me. Thanks

 

[Fluff]

What do you want to return if they are both values?

 

[mpapa01]

What do you want to return if they are both values?

For illustration purposes it was just a sum formula if the statement was true (ie if both cells were hardcoded)

 

[Fluff]

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