|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 27th, 2009, 04:20 PM
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
October 27th, 2009, 04:36 PM
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
October 27th, 2009, 04:42 PM
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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
