ExcelBanter - formulas, if/then

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - formulas, if/then (https://www.excelbanter.com/excel-discussion-misc-queries/246684-formulas-if-then.html)

nan4ca

formulas, if/then

Is there a way to set up a worksheet so that if a condition is met in a cell
then a formula will be performed in another?

Ex.: If, in A1, the data is equal to 1, then a formula in B1 will be
performed.

Sean Timmons

formulas, if/then

Well, you can have the formula in B1 say:

=IF(A1=1,your formula,"")

"nan4ca" wrote:

Is there a way to set up a worksheet so that if a condition is met in a cell
then a formula will be performed in another?

Ex.: If, in A1, the data is equal to 1, then a formula in B1 will be
performed.

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