How to use IF function with multiple sheets

Question

I need help with writing a formula that will calculate the Heavy label, based on the Mass(kg) and the Heavy Mass Threshold Criteria in the Shipping Information sheet. 1 represents a heavy package, and 0 represents not heavy. A mass of 50kg OR heavier is considered as heavy. I have only been able to write the formula manually by stating =IF(D4>=50,1,0). How do I go about including the shipping information in my formula?

Answer 1

I need help with writing a formula that will calculate the Heavy label, based on the Mass(kg) and the Heavy Mass Threshold Criteria in the Shipping Information sheet. 1 represents a heavy package, and 0 represents not heavy. A mass of 50kg OR heavier is considered as heavy. I have only been able to write the formula manually by stating =IF(D4>=50,1,0). How do I go about including the shipping information in my formula?

Hi kaytam,

Can you elaborate on

" How do I go about including the shipping information in my formula?"

What does that mean? There's something missing in how you are describing that particular verbiage.

What is the process that you haven't mentioned?

Could it be

IF('Shipping Information'!$B$4>=50, 1,0)?

by the way you need to remove the > in the shipping information and just put 50 in that cell.

cheers

Answer 2

Hello kaytam,

I am an independent advisor and Microsoft office user.

You can use the if statement with the AND condition to reference the cell in the other sheet. example

=IF((AND(D4>=50, ShippingInformationsheet!C4= ">50")),0, 1)

I have put the >50 in quotes because this will be checked as a character.

Let me know if this points you in the direction you want to take with this.

All the best.

Answer 3

"How do I go about including the shipping information in my formula?"

I think you are going to need to add additional information as to what this means.