Can't find excel formula
Closed
korky
-
Jul 24, 2010 at 05:16 PM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jul 24, 2010 at 09:34 PM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jul 24, 2010 at 09:34 PM
Related:
- Can't find excel formula
- 1st, 2nd, 3rd position formula in excel ✓ - Office Software Forum
- Excel date format dd.mm.yyyy - Guide
- Number to words in excel formula - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Position formula in excel - Excel Forum
1 reply
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
810
Jul 24, 2010 at 09:34 PM
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,"")