If........then......

N

nan4ca

Is it possible to create a formula that if a condition is met in a cell, then
go to another cell and perform formula in that cell?

For Ex.: If the data in cell A1 is greater than or equal to 1, then the
formula in B1 is performed.
 
R

Ron Rosenfeld

Is it possible to create a formula that if a condition is met in a cell, then
go to another cell and perform formula in that cell?

For Ex.: If the data in cell A1 is greater than or equal to 1, then the
formula in B1 is performed.
Click to expand...

B1: =if(a1>=1,"do formula","")

--ron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transfer data between two tables 3
formulas, if/then 1
Newbie Help - IF Yes No Function 0
Excel - Wich Function should I use? 1
Greater Less or Equal 3
Excel does not accept text format! 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Copy addition formula of non-consecutive horizontal cells 2

Top