google sheets multiply ifs

How we can do this in google sheet? multiply based on condition

stackoverflow.com › questions › 58334355 › how-we-can-do-this-in-google-sheet-multiply-based-on-condition

you can use arrayformula:

=ARRAYFORMULA(IF(B2:B<>"", IF((B2:B > 649)*(B2:B < 850), 125, B2:B* 0.16), ))

Answer from player0 on Stack Overflow

Stack Overflow

stackoverflow.com › questions › 58334355 › how-we-can-do-this-in-google-sheet-multiply-based-on-condition

if statement - How we can do this in google sheet? multiply based on condition - Stack Overflow

Top answer

1 of 2

4

Add the following formula to the cell C1, and fill down as necessary

=IF(A1="keyword",B1*2,B1)

References
IF - Google Editors Help

2 of 2

1

If you need to do this for multiple values across the board down the entire column for automation purposes, you can also use the following formula:

=IF(
OR(A:A = "Keyword 1", A:A = "Keyword 2"), 
B:B*2, 
           IF(A:A = "Keyword 3", 
               B*B*3,
               ))

Arab Psychology

scales.arabpsychology.com › home › how to easily multiply values with criteria in google sheets

How To Easily Multiply Values With Criteria In Google Sheets

November 28, 2025 - Unlike dedicated functions found ... MULTIPLY IF function. Instead, users must nest the ARRAYFORMULA, the PRODUCT function, and the IF function to create a robust and dynamic solution....

Simular

simular.ai › workflow › how-to-master-google-sheets-multiple-if-formulas-guide

How to Master Google Sheets Multiple IF Formulas Guide

August 13, 2026 - You can write: IF(AND(B2 = "US", A2 > 80), "Hot", "Other") Or for multiple allowed countries, use OR inside AND. ... Test with rows where you know the expected outcome. Add a helper column explaining the rule in plain English. Keep one "sandbox" sheet where you experiment before touching production dashboards. ... Full control and transparency over logic. No extra tools required beyond Google Sheets.

Stack Overflow

stackoverflow.com › questions › 79200727 › using-multiple-ifs-on-google-sheets

using Multiple IFs on Google sheets - Stack Overflow

November 18, 2024 - I have 2 Columns: Value Date and Trade Date , there are multiple rows which will have value I need a logic where, if Trade Date = Value date (which can be in multiple rows) then sum up all the values and show in one column. If trade Date not equal to value date then sum all and display in different column · Here is sample sheet - https://docs.google.com/spreadsheets/d/1osNd-iS5ZkKzrX6cyVlp2z1VN4GV9LI4kctZ2jQ-N6k/edit?usp=sharing

Find elsewhere

Google Bing Mojeek

reddit.com › r/googlesheets › how do i make an if ">40"multiply formula?

r/googlesheets on Reddit: How do I make an IF ">40"MULTIPLY formula?

July 30, 2022 -

=ARRAYFORMULA(PRODUCT(IF(AG15,">40",AH15,"31.5")))

=ARRAYFORMULA(IF(AG15,">40"(PRODUCT(AH15, 31.5))))

=IF ( AG15, ">40" MULTIPLY(AH15,31.5))

Long story short, those are a few different examples of what I've tried already. Basically what I want to do is calculate the amount of overtime pay my employees earn. So when a cell in column AG is greater than 40, it tells me in column AH how much of that is overtime. Then a another cell needs to calculate the wage paid for that overtime which is (obviously) a different rate than the normal rate that is calculated already as well.

https://imgur.com/a/pbMHvIm

Link to screenshot for reference. Sorry I'm not sure how to post the picture directly. Any help would be appreciated.

Top answer

1 of 3

1

Also to clarify I currently use a simple =MINUS(AH15,40) to calculate the hours of OT and then down towards the bottom where it calculates the dollar amount is a simple =MULTIPLY(AH15,31.5) BUT that results in a bunch of negative numbers if the OT is 0 or less which is fine as you can see i just changed the text color so its barely visible but i was hoping to avoid that with some sort of "IF then MULTIPLY" formula if its even possible. Thanks again for any help!

2 of 3

1

Not in front of my computer to test but I believe this should work to calculate the OT pay. =ARRAYFORMULA( IF( LEN($AH15:$AH31), $AH15:$AH31*31.5, ) ) Try this to go straight from total hrs to OT pay. =ARRAYFORMULA( IF( LEN($AG15:$AG31), IF( $AG15:$AG31>40, ($AG15:$AG31-40)*31.5, ), ) )

LiveFlow

liveflow.com › product-guides › multiply-function-in-google-sheets

MULTIPLY Function in Google Sheets: Explained | LiveFlow

Note that the MULTIPLY formula ... formatting your next financial spreadsheet! ... You can also use the =MULTIPLY formula to multiply the contents of cells. For example, if ......

Alphr

alphr.com › home › how to multiply in google sheets

How to Multiply in Google Sheets

July 10, 2021 - Open your spreadsheet and type “=SUMPRODUCT (A1:A12*B1:B12)”. Once you press “Enter,” you’ll see the final value in the column where you wrote the formula. If you have a column you wish to multiply by a number in Google Sheets, you ...

W3Schools

w3schools.com › googlesheets › google_sheets_multiplication.php

Google Sheets Multiplication Operator

GS Sort GS Sort Sheet GS Sort By ... MEDIAN MIN MODE OR STDEV.P STDEV.S SUM SUMIF SUMIFS VLOOKUP XOR ... Multiplication uses the * symbol in Google Sheets....

Google Support

support.google.com › docs › thread › 26967763 › multiplying-based-off-if-another-cell-has-text

Multiplying based off if another cell has text... - Google Docs Editors Community

January 28, 2020 - Skip to main content · Google Docs Editors Help · Sign in · Google Help · Help Center · Community · Google Docs Editors · Terms of Service · Submit feedback · Send feedback on

Google Support

support.google.com › docs › thread › 173312908 › multiplying-values-using-if-and-functions

multiplying values using IF < and >= functions - Google Docs Editors Community

July 31, 2022 - Skip to main content · Google Docs Editors Help · Sign in · Google Help · Help Center · Community · Google Docs Editors · Terms of Service · Submit feedback · Send feedback on

Google Support

support.google.com › docs › thread › 180808528 › conditional-multiplication

Conditional multiplication - Google Docs Editors Community

September 24, 2022 - Skip to main content · Google Docs Editors Help · Sign in · Google Help · Help Center · Community · Google Docs Editors · Terms of Service · Submit feedback · Send feedback on

Coefficient

coefficient.io › home

How to Multiply in Google Sheets: A Step-by-Step Guide

September 2, 2025 - Simply type: multiply together each value in the points column B in sheet18 if the corresponding value in the team column is equal to “Mavs”. Then press ‘Build’. Formula Builder will automatically generate your sort formula.

Excel Insider

excelinsider.com › home › our blog › google sheets functions › how to use if formula in google sheets with multiple conditions

How to Use IF Formula in Google Sheets with Multiple Conditions - Excel Insider

July 10, 2025 - Learn how to use the IF formula in Google Sheets with multiple conditions by combining IF with AND, OR, and using the IFS function.

Lifewire

lifewire.com › multiply-in-google-spreadsheets-3123883

Create a Formula in Google Sheets to Multiply Numbers

November 29, 2022 - Learn how to multiply two or more numbers in Google Spreadsheets using a simple formula and the ArrayFormula function with a step-by-step example.

Ablebits

ablebits.com › ablebits blog › google sheets tips › google sheets functions › google sheets if function – usage and formula examples

Google Sheets IF function – usage and formula examples

February 27, 2023 - Enter them as you always do and the add-on will recognize the data type. select required comparison operators from the suggested drop-down lists. if needed, add multiple logical expressions in a click: IF OR, IF AND, ELSE IF, THEN IF.

Superjoin

superjoin.ai › home › blog › how to multiply in google sheets: a comprehensive guide

How to Multiply in Google Sheets: A Comprehensive Guide | Superjoin

June 10, 2024 - You can also multiply the values of two cells by referencing their cell addresses: Select the cell where you want the result to appear. ... Enter the cell address of the first value (e.g., A1). ... Enter the cell address of the second value (e.g., B1). Press Enter. For instance, if cell A3 contains the value 3 and cell B3 contains the value 8, the formula =A1*B1 would result in 24. Google Sheets also provides a built-in MULTIPLY function that allows you to multiply multiple values or cell references together:

Spreadsheet Point

spreadsheetpoint.com › home › google sheets tips › how to multiply in google sheets and excel

How To Multiply in Google Sheets and Excel

February 9, 2024 - While the MULTIPLY sheets formula is quick and easy to use, it can only be used with two values. Therefore, if you have more than two values and try to use this formula, it will give display an error. You can also use the multiply operator (an asterisk sign *) to multiply two or more cells or numbers in Google Sheets.

Better Sheets

bettersheets.co › formulas › multiply

MULTIPLY Google Sheets Formula: Returns the product of two numbers. Equivalent...

ARRAYFORMULA() IF() ISBLANK() MAX() Most Common Errors and How To Handle Them in Google Sheets · Today we're gonna talk about errors in Google Sheets and how you can fix... Beginner · CONCATENATE() VLOOKUP() Unlock these tutorials · Learn more about the MULTIPLY() formula: Generate a MULTIPLY() formula for your needs ·