Microsoft Office Forums - View Single Post - Function Finder

Thread: Function Finder

View Single Post

Old

01-01-2012, 11:59 PM

Catalin.B

Catalin.B is offline

Catalin.B uses Windows Vista

Windows Vista Catalin.B uses Office 2010 32bit

Catalin.B uses Office 2010 32bit

Office 2010 32bit

Expert

Join Date: May 2011

Location: Iaşi, România

Posts: 386

Catalin.B is on a distinguished road

Default

You can try something like this:
IF(COUNTIF(A1:A20;"Apple")>2;"You already had two apples today";COUNTIF(A1:A20;"Apple"))

Reply With Quote