Put your second in the false of the first instead of the "". It is called nesting:

=IF(ISNUMBER(SEARCH("btc", I2)), (E2*(1+10%)-D2),IF(ISNUMBER(SEARCH("pp",I2)),E2-D2,""))
Answer from Scott Craner on Stack Overflow
🌐
Google Support
support.google.com › docs › answer › 3093364
IF function - Google Docs Editors Help
Returns one value if a logical expression is `TRUE` and another if it is `FALSE`. Sample Usage IF(A2 = "foo","A2 is foo") IF(A2,"A2 was true","A2 was false") IF(TRUE,4,5) Syntax IF(logical_expre
IF function
IF() - AppSheet Help
ISFORMULA
IFS function
Use If expressions in templates - AppSheet Help
More results from google.com
🌐
GeeksforGeeks
geeksforgeeks.org › google sheets › google-sheets-if-else
Google Sheets IF ELSE - GeeksforGeeks
September 30, 2025 - ELSE: Defines what to do if the condition is false. In Google Sheets, the IF ELSE functionality is achieved using the IF function.
Discussions
excel - How to do an If Else in google sheets? - Stack Overflow
Right now I'm trying to figure out whether a cell contains one of two values, it will then perform an operation which depends on whatever value is in said cell. This is the function I have so far: ... More on stackoverflow.com
🌐 stackoverflow.com
Is there a function similar to an else or elif function?
Maybe I’m not understanding correctly, but it sounds like you are just wanted to do a nested IF condition. =IF(condition, what happens if true, what happens if false) In the “what happens if false” you simply do another IF statement (your Else), and for the “what happens if false” for that one you do another IF statement, and so on. It works outside -> in, so make sure it’s “sequential”. More on reddit.com
🌐 r/googlesheets
7
1
August 29, 2022
How to insert an ELSE IF in as google sheets, as I can't seem to use 2 IF Statements in the same cell? - Stack Overflow
I am trying to make a formula that changes depending on the cell containing the sex value however I can't seem to correct it. I am new to spreadsheets so I may be missing a big and obvious step. =I... More on stackoverflow.com
🌐 stackoverflow.com
Google spreadsheets IF-ELSE - Stack Overflow
I want to add specific amount of time to a date. I have a date (german formatting/ dd.mm.yy) in C2. Then I have a duration in D2, which is either in years or month. (1 year, 2 years or 1 month, 2 m... More on stackoverflow.com
🌐 stackoverflow.com
Videos
08:45
🌐 YouTube
Google Sheets - IF function - YouTube
July 14, 2024
🌐 youtube.com
How to Use IF Function in Google Sheets
02:16
🌐 YouTube
How to use IF Statement in Google Sheets (True or False) - YouTube
January 26, 2024
03:10
🌐 YouTube
How To Do Multiple IF Statements In Google Sheets (Easiest Way) ...
July 14, 2025
View all
View all
🌐
Reddit
reddit.com › r/googlesheets › help with if/else formula
r/googlesheets on Reddit: Help with If/Else formula
November 8, 2023 -

I'm not sure what I'm doing wrong here:

I have a nested IF formula that works as is, except if the "F" cell is empty, the cell fills with "FALSE". I'd rather have it return nothing. But, I'm obviously missing something simple in my syntax.

in short:

this works, but empty "F" cells will return a value of FALSE.

=IF(AND(F6>0, F6<=2),210, IF(AND(F6>2,F6<=5), 450, IF(AND(F6>5, F6<=10), 750, IF(F6>10, ((F6-10)*150)+750))))

I tried adding IF(F6 = " ", " "), but it's giving me #N/A, maybe I'm adding it in the wrong spot?

TIA

Top answer
1 of 3
2
You're missing the else result on the innermost (last) IF, so it defaults to false. Also take a look at IFS for a cleaner formula, and ISBETWEEN.
2 of 3
1
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread: Fewer Letters | More Letters | FALSE | Returns the logical value FALSE | Last usage | Returns one value if a logical expression is TRUE and another if it is FALSE | Last usage | Evaluates multiple conditions and returns a value that corresponds to the first true condition. | Last usage | Checks whether a provided number is between two other numbers either inclusively or exclusively. | Last usage | Returns the argument provided as a number | TRUE | Returns the logical value TRUE NOTE: Decronym for Reddit is no longer supported, and Decronym has moved to Lemmy; requests for support and new installations should be directed to the Contact address below. 4 acronyms in this thread; the most compressed thread commented on today has 6 acronyms. [Thread #6155 for this sub, first seen 8th Nov 2023, 16:52] [FAQ] [Full list] ^[Contact] [Source code]
🌐
YouTube
youtube.com › watch
How to Use IF and IFS Functions in Google Sheets Fast! - YouTube
06:43
Mastering the IF, IFS, and IFERROR functions in Google Sheets is the key to creating smart, automated, and error-free reports! This ultimate guide breaks dow...
Published: September 29, 2025
🌐
Google Support
support.google.com › docs › answer › 7014145
IFS function - Google Docs Editors Help
Evaluates multiple conditions and returns a value that corresponds to the first true condition. Sample Usage IFS(A1>90, "A", A1>80, "B", A1>70, "C") IFS({A1:A5} > 3, "bigger", {A1:A
🌐
Stack Overflow
stackoverflow.com › questions › 42938054 › how-to-do-an-if-else-in-google-sheets
excel - How to do an If Else in google sheets? - Stack Overflow
Top answer
1 of 2
31

Put your second in the false of the first instead of the "". It is called nesting:

=IF(ISNUMBER(SEARCH("btc", I2)), (E2*(1+10%)-D2),IF(ISNUMBER(SEARCH("pp",I2)),E2-D2,""))
2 of 2
5

Alternate with nested IFERROR functions.

=IFERROR(E2*IFERROR(SIGN(SEARCH("btc",I2))*110%,SIGN(SEARCH("pp",I2)))-D2,"")
Find elsewhere
🌐
YouTube
youtube.com › watch
Google Sheets IF Statement: Examples with If, Then, and Or - YouTube
08:04
The IF statement in Google Sheets tests against a condition or conditions that you define and returns a result, based on if the condition is true or false. D...
Published: November 10, 2022
🌐
Coursera
coursera.org › coursera articles › data › data analytics › how to use the google sheet 'if-then' formula
How to Use the Google Sheet 'IF-THEN' Formula | Coursera
April 2, 2026 - The IF-THEN formula in Google Sheets allows you to perform conditional calculations based on specific criteria in your data. This function can help automate decision-making and perform different actions with your information.
🌐
W3Schools
w3schools.com › googlesheets › google_sheets_if.php
Google Sheets IF Function
GS Sort GS Sort Sheet GS Sort By ... ... The IF function is a premade function in Google Sheets, which returns values based on a true or false condition....
🌐
Reddit
reddit.com › r/googlesheets › is there a function similar to an else or elif function?
Is there a function similar to an else or elif function? : r/googlesheets
August 29, 2022 - I’ve only got 8 different possible outcomes so I thought I would just do 8 consecutive IF functions and it would just run the one that is correct but instead it’s just saying error. I don’t know if I need a function similar to an else or elif statement in python
🌐
Stack Overflow
stackoverflow.com › questions › 72578272 › how-to-insert-an-else-if-in-as-google-sheets-as-i-cant-seem-to-use-2-if-statem
How to insert an ELSE IF in as google sheets, as I can't seem to use 2 IF Statements in the same cell? - Stack Overflow
=IF(C3="Female" (655.1+(9.563C6)+(1.850C7)-(4.676C4)) ELSE IF (C3="Male" (66.5+(13.75C6)+(5.003C7)-(6.75C4)))) if-statement · google-sheets · formula · Share · Short permalink to this question · Improve this question · Follow · Follow ...
🌐
Sheetgo
sheetgo.com › home › how to use the if function in google sheets
How to use the IF function in Google Sheets - Sheetgo
December 17, 2025 - Again, in simple terms, I’m telling the function “Evaluate if B2 is 0, if it’s TRUE output ‘No experience’, if it’s FALSE continue to the next IF statement. Evaluate if B2 is less than 4, if it’s TRUE output ‘Some experience’, if it’s FALSE output ‘Lots of experience’ ”. The AND and OR logical functions in Google Sheets can be used in combination with the IF function.
🌐
Medium
medium.com › @gaillereports › google-sheets-full-overview-of-if-ifs-and-and-or-formulas-2e7f61c6b8e9
Google Sheets - Full Overview of IF, IFS, AND and OR formulas | by Gala Ivannikova | Medium
April 25, 2025 - That’s pretty much the formula ... change anything. The OR formula in Google Sheets is used to test multiple conditions and returns TRUE if at least one of the conditions is met; otherwise, it returns FALSE....
🌐
Stack Overflow
stackoverflow.com › questions › 75227783 › google-spreadsheets-if-else
Google spreadsheets IF-ELSE - Stack Overflow
Top answer
1 of 1
1

Try this in G2:

=lambda(splitdate;addtime;
lambda(month;year;addamnt;addunit;
date(100+year+(regexmatch(addunit;"year")*addamnt);month+(regexmatch(addunit;"month")*addamnt)+1;1))(
index(splitdate;;2);index(splitdate;;3);index(addtime;;1);index(addtime;;2)))(
split(C2;".");split(D2;" "))

N.B. 1: The output is in dd/mm/yyyy format; use a custom number format to convert this back into dd/mm/yy for display. N.B. 2: I've assumed that you want to round the result to the first day of the next month even if the date in D2 is the first day of a month; it's a fairly simple modification if this isn't what you want to do.

🌐
Sheets Bootcamp
sheetsbootcamp.com › home › if statements › google sheets if function: complete guide
Google Sheets IF Function: Complete Guide | Sheets Bootcamp
11:50
If you write =IF(A1>100, "Yes") without a third argument, the false result is the boolean value FALSE, not a blank cell. This can break formulas that reference the cell later. ... The empty string "" displays as a blank cell and doesn’t interfere with other formulas. Comparing text to a number does not error, and that is the trap. Google Sheets sorts every text value above every number, so the comparison quietly comes out TRUE:
Published: February 18, 2026
🌐
W3Schools
w3schools.com › r › r_if_else.asp
R If...Else Conditions
In this example we use two variables, ... in the code. The else if keyword is R's way of saying "if the previous conditions were not true, then try this condition":...
🌐
Simplify Sheets
simplifysheets.com › home › google sheets functions › if function – google sheets
IF Function – Google Sheets | Simplify Sheets
March 11, 2023 - IFS: Evaluates multiple conditions and returns a value that corresponds to the first true condition. ISBLANK: Checks whether the referenced cell is empty. ... INDEX MATCH vs. VLOOKUP in Google Sheets
🌐
Stack Exchange
webapps.stackexchange.com › questions › 136994 › google-sheets-if-else-formula
Google Sheets If else formula - Web Applications Stack Exchange
Top answer
1 of 2
1

Do I have to use AND?

Yes.
The formula to use would be:

2 of 2
0

The function you are looking could be IF or IFS.

The syntax is for IF is

IF(logical_expression,value_if_true,value_if_false)

The syntax for IFS is

IFS(condition1, value1, [condition2, value2, …])

Reference

  • IF function
  • IFS function
🌐
Google Support
support.google.com › docs › thread › 53830094 › using-if-function-in-google-sheets
Using IF function in Google Sheets - Google Docs Editors Community
June 16, 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
🌐
The Bricks
thebricks.com › home › resources › how to create dashboards with ai
How to Make a Conditional Formula in Google Sheets
April 22, 2025 - Typically, this is as easy as dragging and dropping your CSV or Excel sheet into the browser. The tool's AI will then read your file, analyze its structure and content, and begin generating a dashboard tailored to your dataset.