b32

  1. D

    Multiple IF AND Statements

    Hello If I have the following sets of data Cell K2 = 750000 Cell N9 = YES Cell B32 = 15 What formula can I use to say the following If Cell K2 >500000 and Cell N9 = YES and B32 is less than or equal to 20 then use the the value in cell B32, if it is greater than 20 then use 20 I hope...
  2. A

    Multiple lookup & match problem

    I type a Job name in A1 and a job number in B1 In A12 through A32 I have Job Names In B12 through B32 I have Employee names In D10 through J10 I have the weeks dates In D12 through J12 running down the column to D32 through J32 I have job numbers that match the job names I want the employees in...
  3. W

    Unknown Logical Test in IF formula

    I have a logcal test in an excel if statement that I don't understand, this is a nested if, which I understand completely, my trouble is with the last logical test: IF(1.16 > B32 > E38 .................. What does this do? Does it test if 1.16 is greater than the value in B32 and then test if...
    • wilest
    • Thread
    • b32 greater if statement conditions test understand
    • Replies: 1
    • Forum: Excel Questions

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
Back
Top