Can't find excel formula
Closed
korky
-
Jul 24, 2010 at 05:16 PM
venkat1926
venkat1926
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Related:
- Can't find excel formula
- @ in excel formula ✓ - Forum - Excel
- Excel formula if cell contains text then return value in another cell ✓ - Forum - Excel
- How to ignore false in excel formula ✓ - Forum - Office Software
- Number to words in excel formula - Guide
- Excel formula to transfer data between worksheets - Guide
1 reply
venkat1926
Jul 24, 2010 at 09:34 PM
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Jul 24, 2010 at 09:34 PM
quote
=ifE3<72than6.
unquote
what if E3 is NOT <72. I assumed it will be blank
correct formula will be
=if(E3<72,6,"")
=ifE3<72than6.
unquote
what if E3 is NOT <72. I assumed it will be blank
correct formula will be
=if(E3<72,6,"")
