| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF question
Hi,
Can someone help with the following conditional IF question please: If value in C4 is numeric, then the formula for K4 is C4*J4 rounded to 2 places or if C4 is the text "item" or "Item", then take the value to be 1. If C4 is empty, do nothing. Regards and thanks, Stuart. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF question
=IF(ISNUMBER(C4),ROUND(C4*J4,2),IF(C4="item",1,IF( C4="","","undefined
output"))) -- David Biddulph "Stuart" wrote in message ... Hi, Can someone help with the following conditional IF question please: If value in C4 is numeric, then the formula for K4 is C4*J4 rounded to 2 places or if C4 is the text "item" or "Item", then take the value to be 1. If C4 is empty, do nothing. Regards and thanks, Stuart. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF question
Thanks David.
How do I change it so that if C4 is empty of any data, then J4 stays blank, please? Regards, Stuart. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF question
=IF(C4="","","whatever you want J4 to be in the cases where C4 isn't blank")
-- David Biddulph "Stuart" wrote in message ... Thanks David. How do I change it so that if C4 is empty of any data, then J4 stays blank, please? Regards, Stuart. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| where can I see my question and answer? Yesterday I ask a question | Excel Discussion (Misc queries) | |||
| sum if question | Excel Worksheet Functions | |||
| 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 | |||
Hybrid Mode
