simple formula to display Value

Hello Sir,
I'm trying to write a simple formula to check whether either 1 or 2 table are blank and, if so, leave the resulting to display the value of non-blank table.
I want the resulting table to only display a value if all or either 1 table are filled in.

Capture.JPG
These are formula I tried.
=IFERROR(C5,OR(H5,AND(M5))) if c blank then shows blank
=IFERROR(C6,AND(H6,OR(M6))) if c blank then shows blank
=IFERROR(M7,OR(H7,OR(C7))) if m blank then shows blank
=IFERROR((C5,H5,M5),IFERROR((H5,M5),IFERROR((C5,M5),(C5))))

Capture2.JPG
Plz help..
LVL 1
M ZahidAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.ScDirectorCommented:
This looks like excel , remember when you are dealing with empty boxes evaluation , the best way to sort out your problem is to this formula below:

=IFERROR(C5,OR(H5,AND(M5))) if c blank then shows blank

= IF(ISBLANK (C5),"Empty"," Actual Figure")

Your formula is not clear, If I were in your position I will do it like below:

= IF(ISBLANK (C5),0, " actual Figure")

Regards

Chris
M ZahidAuthor Commented:
Hi Chris,

Thx for the response, the formula you have suggested is (if C5 is blank to show "0" if not then show "Actual Figure") its a if formula bro :)

what i want to show the available value from the either of tables above as mentioned.

if c5 blank then read h5 if h5 is blank then read m5 - result it shd read either cell & skip the blank.
Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.ScDirectorCommented:
Okay I see I will back shortly , but confirm whether this is excel or something else because you saying tables
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

M ZahidAuthor Commented:
:) it is excel
Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.ScDirectorCommented:
Okay but still this can be done through the IF evaluation, try the formula below , just replace with your parameters.

=IF(AND(C2<>"",B2<>""),A2-C2,"")

The above will surely do what you want , I have used your formula but just removed IFERROR factor.

Regards

Chris
Rob HensonFinance AnalystCommented:
Try this:

=IF(C5<>"",C5,IF(H5<>"",H5,M5))

In words:

If C5 is not blank then use C5 otherwise if H5 is not blank then use H5 otherwise use M5

If M5 is also blank the result will be zero because a reference to an empty cell just gives zero. If you don't want zero but want it blank:

=IF(C5<>"",C5,IF(H5<>"",H5,IF(M5="","",M5)))

Thanks
Rob

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ShumsExcel & VBA ExpertCommented:
Try below:
=IF(NOT(ISBLANK(C5)),C5,IF(NOT(ISBLANK(H5)),H5,IF(NOT(ISBLANK(M5)),M5,"")))

Open in new window

M ZahidAuthor Commented:
HI Rob, thx for help it [code] =IF(C5<>"",C5,IF(H5<>"",H5,IF(M5="","",M5))) [/code] worked..

Hi Shums, thx for your help too its worked as well..

thanks you guys

& Chirs - i m already using that formula for some other worksheet but that is for - calculation - thx anyhow for the help.
Rob HensonFinance AnalystCommented:
Glad to be of help.

Another option, if only one of the three cells will be populated:

=MAX(C5,H5,M5)
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.