If if?

I have an IF formula to calculate hrs worked but would like to keep the cell blank if there are no values entered in other cell on row (FINISH in this example).

=IF([@Finish]<[@Start], 1-[@Start]+[@Finish], [@Finish]-[@Start])

So i would like to add another argument where =IF[@FINISH]="", THEN""

How do i combine the two into 1?

Hello,

try

=IF([@Finish]="","",IF([@Finish]<[@Start], 1-[@Start]+[@Finish], [@Finish]-[@Start]))

cheers,

Hi TheBarran,

The formulas you suggest and teylyn improved only works if you have defined your data as a TABLE and you are using Excel 2007 or newer. See http://office.microsoft.com/en-us/ex...010155686.aspx
For the fancy name of Structured References when dealing with Excel Tables.

Marvin, I assume that TheBarran pasted the formula straight out of the spreadsheet, so it looks as if the Table is already being used.

Hi

You can simplify your formula to


=IF([@Finish]="","",MOD([@Finish]-[@Start]),1)

Hi teylyn,

I've been fooled by structured references a few times when converting a range to a table and then back to a range. See the example and see how the formulas flip one way but not back. My answer was warning that the table formulas would convert to range but not back if OP converted.

see the example and convert the table to a range and back a few times and look at the formulas in column D.