Excel公式 - 添加单元格+“.jpg”基于B1和C1中的值为空 [英] Excel Formula - Add cell + ".jpg" based on value in B1 and C1 is blank

问题描述

我希望有人可以协助解决这个问题。

我有一个excel表，我想根据单元格的SkU号自动添加一个特定的值，并在另一个单元格中将该。SKU扩展到该SKU。 p>

基本上如果在单元格B2中有一个值，而C2是空白的，我想自动在列I中添加值从B2 + .jpg
然后还添加列M（静态值）颜色:: 1 | Size :: 2

现在我有一个简单的公式在列I = B2&jpg

 
 BCIM 
 product_sku product_parent_sku product_full_image属性
 ABC-0001 ABC-0001.jpg颜色:: 1 |大小:: 2 
 ABC-0001 ABC-0001-1 
 ABC-0001 ABC-0001-2 
 ABC-0002 ABC-0002.jpg颜色:: 1 |大小:: 2 
 
 
 
解决方案
建议嵌套的IF语句或带有AND条件的IF语句离子在I2： -  
  = IF（B2 =，，IF（C2 =，B2& .jpg，））
  
或
  = IF（AND（B2<，C2 =），B2&jpg，）
  
然后，M2填写如果填写了： -  
  = IF（I2 =，，Color :: 1 | Size :: 2）
  
根据需要拉下公式。
 
I hope someone can assist with this issue I can't solve. 

I have an excel sheet that I want to automatically add a specific value based on a cell's SkU number and add a .jpg extension to that SKU in another cell automatically

Basically if there is a value in cell B2 and C2 is blank I want to automatically add in column I the value from B2 + .jpg
Then also add in column M (a static value) Color::1|Size::2

Right now I have a simple formula in Column I =B2&".jpg"
    B                  C                  I                 M
product_sku     product_parent_sku  product_full_image  attributes
ABC-0001                            ABC-0001.jpg        Color::1|Size::2
ABC-0001        ABC-0001-1      
ABC-0001        ABC-0001-2      
ABC-0002                            ABC-0002.jpg        Color::1|Size::2

解决方案
Suggest either nested IF statements or an IF statement with an AND condition in I2:-
=IF(B2="","",IF(C2="",B2&".jpg",""))
or
=IF(AND(B2<>"",C2=""),B2&".jpg","")
Then M2 is only filled in if I2 is filled in:-
=IF(I2="","","Color::1|Size::2")
Pull the formulae down as required.

                        
这篇关于Excel公式 - 添加单元格+“.jpg”基于B1和C1中的值为空的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！