if conditional multiplier

  1. S

    How to multiply the values within the conditional formatting range?

    I have a big data excel file, there are many negative numbers. Now I want to highlight all the negative values and then multiply it with a specific number (for example 0.5). Could you kindly show me how to do it? Thank you.
    • sneakikaz
    • Thread
    • condiational formatting find & replace in formula if conditional multiplier
    • Replies: 18
    • Forum: Excel Questions
  2. H

    Need Formula data based on Multiple text/value conditions

    Hi Team, Can anyone help me with below requirement....here is the data <tbody> Customer Product Name Amount Contribution by Final Status Cust1 Product 1 17,991 Team 1 Cust2 Product 2 19,901 Team 2 Cust3 Product 3 18,948 Team 3 Cust3 Product 3 10,730 Team 1 Cust5 Product 5...
    • harinsh
    • Thread
    • condition if greater than if conditional multiplier multiple array formula team
    • Replies: 10
    • Forum: Excel Questions
  3. D

    IF function with simple muliplication not working...

    I´ve been trying to get the following to work in excel: Rules are: IF E10<30 THEN E22==0 IF E10>=91 BUT E10<=180 THEN E22=(L24*7) IF E10>=181 BUT E10<=364 THEN E22=(L24*15) IF E10>=365 THEN E22=(L24*30) In the following formulation: =IF(E10<90, E22==0,IF((E10>=91 AND(E10<=180))...

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