Linking Tabs w/ formulas

C

Codeman

On the Totals tab/sheet; Cell C34 is to place a word based from the
Mercantile tab/sheet.

I want C34 on my Total sheet to put the information “ALLOWED†or “N/Aâ€.

On the Mercantile tab/sheet Cell B18 formula is as follows;
=IF(B5<=50,"ALLOWED",IF(SUM(C13,C15)>=6,"REQUIRED","N/A"))
B5 is the location I put an occupant load. If the occupant load is 50 or
less then Uni-sex is “ALLOWED†and displayed. If the occupant load is over
50 then “N/A†is to be displayed. When C13 and C15 add up to 6 or more then
“REQUIRED†is displayed. The change would be I do not need the reference to
C13 and C15. The Mercantile tab/sheet cells and their formulas are not to
change.

A cell on my Total tab/sheet above Cell C34 has this formula;
=SUM(Mercantile!B5/Mercantile!C9)*50%
I can sometimes do the simple stuff but when it gets really involved I get
lost. I tried some scenarios but could not get the results I wanted. I know
it has to do with “Mercantile!†put in the formula somewhere and the
parentheses. I also get lost on the IF scenarios.

This one in Cell C34 did not work; =IF(ISERR(Mercantile!B5)<=50,"ALLOWED",0)

Hope someone can help me.
 
T

T. Valko

I don't know what you're trying to do, but....
This...did not work; =IF(ISERR(Mercantile!B5)<=50,"ALLOWED",0)

Maybe this is what you want:

=IF(AND(COUNT(Mercantile!B5),Mercantile!B5<=50),"ALLOWED",0)
 
C

Codeman

I put in N/A after ALLOWED where you had the zero and it worked.
=IF(AND(COUNT(Mercantile!B5),Mercantile!B5<=50),"ALLOWED","N/A")
Thank you,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top