I created a formula where I want in cell B3 what I have in B3 of the previous sheet General if in A3 of the General sheet there is 1 otherwise I would like to have it blank.
I did =IF(General!A3=1,"=General!B3", "blank") but instead of the word written in B3 I read =General!B or I read the word blank.. can somebody help me with that?
IF formula in Excel?
- Posted:
- 3+ months ago by Alex25
- Topics:
- computer, formula, excel, computer software
Details:
Answers (1)
IF function
This article describes the formula syntax and usage of the IF function in Microsoft Excel.
Description
The IF function returns one value if a condition you specify evaluates to TRUE, and another value if that condition evaluates to FALSE. For example, the formula =IF(A1>10,"Over 10","10 or less") returns "Over 10" if A1 is greater than 10, and "10 or less" if A1 is less than or equal to 10.
Syntax
IF(logical_test, [value_if_true], [value_if_false])