#1
|
|||
|
|||
Formula Question
Not sure how to also get an answer for this question: I want to return a # in cell DE2 of 19, if DD2 is = Y. If DD2 is = to N, then DE2 = 0. Not sure how to get this??? Anyone have an answer? Everything I have tried comes back with an error. Been a while since I have tried If statements. |
#2
|
||||
|
||||
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] |
Thread Tools | |
Display Modes | |
|
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 |