Formula Question

		Microsoft Office Forums > Microsoft Excel > Excel
Formula Question

FAQ

Thread Tools

Display Modes

01-23-2015, 04:13 PM

macropod

Windows 7 64bit Formula Question

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,515

Please don't hijack other peoples' threads, especially when your question apparently doesn't even relate to the same application. I've split your post off into a new Excel thread.

From your description, it looks like the formula you need might be:
=IF(DD2="Y",19,0)
or:
=IF(DD2="Y",19,IF(DD2="N",0,""))

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Complex formula question	diverdown87	Excel	7	10-21-2014 07:44 AM
Macro Needed to Insert Asnwer to A Question in Multiple Choice Format Question	rsrasc	Word VBA	7	03-28-2014 12:28 PM
Formula question	H28Sailor	Excel	4	08-20-2013 09:57 AM
SUMIF Formula question	jcaswell	Excel	3	05-22-2011 02:52 AM
Categories question & replying with attachment question	glitzymama	Outlook	0	03-15-2006 09:32 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:41 PM.