Evaluate Multiple Cells for Formulas

mpapa01

New Member
Joined
Dec 1, 2017
Messages
8
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
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

mpapa01

New Member
Joined
Dec 1, 2017
Messages
8
=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

New Member
Joined
Dec 1, 2017
Messages
8

ADVERTISEMENT

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

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
53,186
Office Version
  1. 365
Platform
  1. Windows
Try changing the or to and in WBD' suggestion
 

mpapa01

New Member
Joined
Dec 1, 2017
Messages
8

ADVERTISEMENT

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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
53,186
Office Version
  1. 365
Platform
  1. Windows
What do you want to return if they are both values?
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
53,186
Office Version
  1. 365
Platform
  1. Windows
In that case the formula WBD supplied in post#2 works for me.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,070
Messages
5,599,607
Members
414,323
Latest member
Sacalumbo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top