| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Variation on If Then Else Theme
Hi all,
Wondering if there's a way to change the values in two different cells if condition is true... I want the formula to look at a cell, say T36. If it is blank, "" or null then S3 = S18 AND T3 = T18. Is this possible? cheers DubboPete |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Variation on If Then Else Theme
It's very simple.
In S3 you put the formula =IF($T36="",S18,"whatever result you want if the condition isn't satisfied") Copy to T3 -- David Biddulph DubboPete wrote: Hi all, Wondering if there's a way to change the values in two different cells if condition is true... I want the formula to look at a cell, say T36. If it is blank, "" or null then S3 = S18 AND T3 = T18. Is this possible? cheers DubboPete |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Variation on If Then Else Theme
On Apr 16, 3:58*pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote: It's very simple. In S3 you put the formula =IF($T36="",S18,"whatever result you want if the condition isn't satisfied") Copy to T3 -- David Biddulph DubboPete wrote: Hi all, Wondering if there's a way to change the values in two different cells if condition is true... I want the formula to look at a cell, say T36. * If it is blank, "" or null then S3 = S18 *AND *T3 = T18. Is this possible? cheers DubboPete- Hide quoted text - - Show quoted text - Thanks David! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| variation on SUMIF funciton | Excel Worksheet Functions | |||
| Variation from the mean? | Charts and Charting in Excel | |||
| SUMIF variation? | Excel Worksheet Functions | |||
| How do I add a theme in Excel? | Excel Discussion (Misc queries) | |||
| variation on countif? | Excel Worksheet Functions | |||
Linear Mode
