If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|