| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how: if, conditional test, true (do nothing if false)
I want a simply if then without the else.
|
|
#2
|
|||
|
|||
|
=if(Condtion,true response,"")
will give a blank for a false response, is this what you mean? "jwhitney" wrote: I want a simply if then without the else. |
|
#3
|
|||
|
|||
|
We have daily and weekly (and monthly and biannual) checks, I want the date
on the weekly to update (dd/mm/yy) on "Mon" but not change the rest of the week. "bj" wrote: =if(Condtion,true response,"") will give a blank for a false response, is this what you mean? "jwhitney" wrote: I want a simply if then without the else. |
|
#4
|
|||
|
|||
|
=TODAY()-WEEKDAY(TODAY()-2)
-- HTH Bob Phillips "jwhitney" wrote in message ... We have daily and weekly (and monthly and biannual) checks, I want the date on the weekly to update (dd/mm/yy) on "Mon" but not change the rest of the week. "bj" wrote: =if(Condtion,true response,"") will give a blank for a false response, is this what you mean? "jwhitney" wrote: I want a simply if then without the else. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if logical test true, then hlookup, if false then difference betwe | Excel Worksheet Functions | |||
| Office2000: Conditional format behaves strangely | Excel Discussion (Misc queries) | |||
| Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
| Grand Totals @ Same Place | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
