Can't find excel formula

Question

Can't find excel formula

[Closed]

Report

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?

Can't find excel formula
@ in excel formula ✓ - Forum - Excel
Excel formula if cell contains text then return value in another cell ✓ - Forum - Excel
Excel formula bar missing - How-To - Excel
Excel formula to transfer data between worksheets - How-To - Excel
Excel formula for position ✓ - Forum - Office Software

1 reply

Ask a question

venkat1926 · Answer 1 · 2010-07-24T21:34:19-0400

Answer 1 / 1

venkat1926

Posts: 1864
Registration date: Sunday June 14, 2009
Status: Contributor
Last seen: August 7, 2021

802
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,"")

Can't find excel formula

1 reply

Your reply

Subscribe To Our Newsletter!