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 810
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