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
Hello,
i have been trying to find a formula for my excel spredsheets. i thought the Formula should be =ifE3<72than6. it comes up as an error. can any one help?


1 reply

venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
805
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,"")
0