If statements
Solved/Closed
oshngzr
-
28 Nov 2011 à 14:50
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 28 Nov 2011 à 21:25
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 28 Nov 2011 à 21:25
Related:
- If statements
- How many if statements can you nest in excel - Guide
- If statement with dates - Guide
- 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
- Conditional formatting if statement ✓ - Excel Forum
- Numeric value - Facebook Forum
1 response
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
28 Nov 2011 à 21:25
28 Nov 2011 à 21:25
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,""))
