I've go a doozy here. Please see attached worksheet/order form.
What formula can I use for "if at least 2 cells have a value, then return same value into cell x"?
For header 'MENS' LINE", I'd like for cell B27 to return the same value of the entry into cell BC22 and/or BC23 and/or BC24 and/or BC25.
Im making an order form. The customer is required to select 2 of the 4 products to qualify. The quantities that the customer will enter into the 2 selected
cells will match. For example the customer enters "1" into cell BC22 and "1" into cell BC25, i would like for BC27 to auto-fill with "1".
Thank you!
BC27? That cell is a header - "Acne/ Problematic Skin Line"
Also, cells BC22:BC25 should be set as "Numbers". Right now if you type a number in, it sees it as text, not a number.
Regardless, whatever cell you want it to show up in, you can enter this formula:
=IF(COUNTA(BC22:BG25)>1,MAX(BC22:BG25),"")
