Linking Tabs w/ formulas

  • Thread starter Thread starter Codeman
  • Start date Start date
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.
 
I don't know what you're trying to do, but....
This...did not work; =IF(ISERR(Mercantile!B5)<=50,"ALLOWED",0)
Click to expand...

Maybe this is what you want:

=IF(AND(COUNT(Mercantile!B5),Mercantile!B5<=50),"ALLOWED",0)
 
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,
 
Back
Top