Thank you soooo much can I add a third say if j9 is camera =$100?Welcome to the Board!
Formula to put in cell J9:
and format cell J9 as currency to get your dollar sign.Excel Formula:=IF(K9="cable",50,IF(K9="jet",150,""))
=IF(K9="cable",50,IF(K9="jet",150,IF(K9="camera",100,"")))
=IF(K9="cable",50,IF(K9="jet",150,IF(K9="camera",100,0)))
=IF(K9="cable",50,IF(K9="jet",150,IF(K9="camera",100,IF(K9="",0,""))))