This is from a time sheet download. I am trying to figure out how this
statement works.
This is from a time sheet download. I am trying to figure out how this
statement works.
If either B11 or B10 is blank, set the value of the cell to zero
Otherwise, if B11 is less than B10 set the value of the cell to .....
I could expand on this, but the formula was cut off in the subject line.
--
Les Torchia-Wells
"Dave" wrote:
> This is from a time sheet download. I am trying to figure out how this
> statement works.
Dave,
The formula you've put in the subject looks clipped so this may not be
everything, but basically:
If B11 Or B10 are empty the result is 0 and the rest of the formula is
ignored.
If B11 Or B10 contain any value at all then another condition is tested:
If B11 < B10 then the result will be ((B11 - B10) * 24) + 24
If B11 > B10 then the result will be B11 - B10
Hope that helps
Best regards
John
"Dave" <[email protected]> wrote in message
news:[email protected]...
> This is from a time sheet download. I am trying to figure out how this
> statement works.
.....Sorry revise the second part to:
If 'both' B11 and B10 contain any value at all then another condition is
tested:
If B11 < B10 then the result will be ((B11 - B10) * 24) + 24
If B11 > B10 then the result will be B11 - B10
.....must read the question
"John" <[email protected]> wrote in message
news:[email protected]...
> Dave,
>
> The formula you've put in the subject looks clipped so this may not be
> everything, but basically:
>
> If B11 Or B10 are empty the result is 0 and the rest of the formula is
> ignored.
>
> If B11 Or B10 contain any value at all then another condition is tested:
> If B11 < B10 then the result will be ((B11 - B10) * 24) + 24
> If B11 > B10 then the result will be B11 - B10
>
> Hope that helps
>
> Best regards
>
> John
>
>
> "Dave" <[email protected]> wrote in message
> news:[email protected]...
>> This is from a time sheet download. I am trying to figure out how this
>> statement works.
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks