ExcelBanter - Is there a wildcard for if then functions

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Is there a wildcard for if then functions (https://www.excelbanter.com/excel-worksheet-functions/183416-there-wildcard-if-then-functions.html)

Sal

Is there a wildcard for if then functions

I want the cell containing the function to be populated if the corresponding
cell is populated.

I tried typing IF(A1="*", 50, "")

Gary''s Student

Is there a wildcard for if then functions

=IF(A1="","",50)
--
Gary''s Student - gsnu200778

All times are GMT +1. The time now is 09:52 AM.