Can't find excel formula

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
quote
=ifE3<72than6.
unquote

what if E3 is NOT <72. I assumed it will be blank

correct formula will be

=if(E3<72,6,"")