| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If........then......
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If........then......
On Tue, 27 Oct 2009 09:20:02 -0700, nan4ca
wrote: 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. B1: =if(a1=1,"do formula","") --ron |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If........then......
=if(A1=1, "Your Calc Here", "")
-- HTH... Jim Thomlinson "nan4ca" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
