excel conditional

  1. T

    Make cells only able to insert amount of specific cell and its multiple value

    Hi guys, is there any way to make some specific cells to only able insert a specific amount and the multiple of it? also, is there any way to make a cell count by the value of the data and the multiple of it? let's say that from the table below, I type price per amount 10,000, then the user is...
  2. W

    If or statements containing multiple calculation depending on cell values

    Hi, I have a workbook with multiple worksheets and table. I am trying to perform calculation depending on selected values in cell Column A. so in B1 I want the following to happen if A1=ID 1 then do the following calculation C1*exp(-0.5/4)*(22-C1), or if A1=ID 2 then do this calculation...
    • wh0
    • Thread
    • excel excel & ilogic excel conditional
    • Replies: 2
    • Forum: Excel Questions
  3. H

    Conditional formatting a cell on another cells output, which is a formula

    Hello I would like to format a cell, with warning colours, when another cell displays " Unusual pattern on plate 8. Please Check" The formula is the active cell is: =IF(AND(BX207<400,N17<>"")," Unusual pattern on plate 8. Please Check","") In N17 I would to format the text Bold...
  4. B

    Conditional Formatting with Several Conditions

    Good Morning, How can you create conditional formatting with several conditions? For example.. <colgroup><col span="7"></colgroup><tbody> GRADE ON 200 MESH </tbody> 20EXT24 15 20EXT24 32 ULD 14 ULD 24 I am...
  5. P

    How to append a text string to all cells beginning with a number

    Hi all, I have a dataset of 50,000 historical addresses (very messy). Some of these have the structure: |4 example street| I know that if the address begins with a number it belongs to a particular city. I want to append this to each of these cells to get: |4 example street city| I...

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