| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If - Then question
How would I write a formula to handle this problem?
If the value in cell D20 is €˜U18 then the result in cell D6 is a €˜0 however if the value in D20 is anything else then the result in cell D6 is the value in N5 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If - Then question
Try this entered in D6:
=IF(D20="U18",0,N5) Or: Assuming N5 is a numeric value. =(D20<"U18")*N5 -- Biff Microsoft Excel MVP "Ksean" wrote in message ... How would I write a formula to handle this problem? If the value in cell D20 is 'U18' then the result in cell D6 is a '0' however if the value in D20 is anything else then the result in cell D6 is the value in N5 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If - Then question
I went with your second option and it worked great!
Thanks. "T. Valko" wrote: Try this entered in D6: =IF(D20="U18",0,N5) Or: Assuming N5 is a numeric value. =(D20<"U18")*N5 -- Biff Microsoft Excel MVP "Ksean" wrote in message ... How would I write a formula to handle this problem? If the value in cell D20 is 'U18' then the result in cell D6 is a '0' however if the value in D20 is anything else then the result in cell D6 is the value in N5 . |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If - Then question
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Ksean" wrote in message ... I went with your second option and it worked great! Thanks. "T. Valko" wrote: Try this entered in D6: =IF(D20="U18",0,N5) Or: Assuming N5 is a numeric value. =(D20<"U18")*N5 -- Biff Microsoft Excel MVP "Ksean" wrote in message ... How would I write a formula to handle this problem? If the value in cell D20 is 'U18' then the result in cell D6 is a '0' however if the value in D20 is anything else then the result in cell D6 is the value in N5 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Question 1 of ??? | Excel Worksheet Functions | |||
| where can I see my question and answer? Yesterday I ask a question | Excel Discussion (Misc queries) | |||
| VB Question | Excel Discussion (Misc queries) | |||
| Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
| The question is an excel question that I need to figure out howto do in excel. | Excel Worksheet Functions | |||
Linear Mode
