If statements
Solved/Closed
oshngzr
-
Nov 28, 2011 at 02:50 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 28, 2011 at 09:25 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 28, 2011 at 09:25 PM
Related:
- If statements
- How many if statements can you nest in excel - Guide
- Excel if statements with dates - Guide
- Conditional formatting if statement ✓ - Excel Forum
- Multiply if statements ✓ - Excel Forum
- Which two sentences correctly describe the use of formulas in performing calculations in spreadsheets? all formulas written for a spreadsheet must follow certain rules, which we call syntax. when creating a formula in a spreadsheet, always start with an if statement. basic statements include numeric values and operators. if there are multiple operators, then the order of precedence starts with exponents. parentheses are used to isolate certain parts of the expression from the other parts. operations in parentheses are completed after the rest of the formula is evaluated. - Excel Forum
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Nov 28, 2011 at 09:25 PM
Nov 28, 2011 at 09:25 PM
use this formula in an empty cell
=IF(AND(B5<150000,B5>0),52,IF(B5=0,0,""))
=IF(AND(B5<150000,B5>0),52,IF(B5=0,0,""))
