I need the formula to check the 2 "text" values and 1 numerical value in three different cells and if all three are valid, multiply their corresponding numerical values which are located in three other different cells. Here is my formula (which is not working):
=PRODUCT(IF(b5 ="Text",d5="Text",e5=number,(s7*s33*s23),""))
Any ideas?
Bookmarks