Multiple IF format

[VDayHero]

Hi All,
I am trying to set up a timesheet for work using the following formula



=IF
($A$8<>,
(if
($D$6>=$D$5+TIME(8,0,0),
8,0)
),
"")

a basic rundown is that my 2nd "IF" string works, just trying to make it work with the 1st one

IF A8 has data - continue second IF string
IF A8 is blank - enter blank value

IF difference between D6 and D5 is greater than 8 - input 8
IF difference between D6 and D5 is less than 8 - input the difference,

If there is no way to make this work is there another option?

Thanks in advance

[TMS]

Please Login or Register  to view this content.

[SCLai]

Hi Vday,

I'm not very sure but perhaps is it because you did not place a pair of " to represent blank?
=IF ($A$8<>"", (if ($D$6>=$D$5+TIME(8,0,0), 8,0)),"")

On my side, the formula you have came up with worked perfectly fine with the added "".
Attachment 653646

Edit: Should have refreshed before posting after idling for an hour but like what TMS has stated, it should be the pair of double quotes.