Nested IF statement

[Paul long]

Hi Guys,
New to the board.
I'm struggling with a nested IF on a sheet that logs fork lift repairs.
Column K allows me to mark with a "Y" if the job is complete, and if so I want column N to calculate the number of days between the reported date and the repaired date, if it's not been repaired yet, then calculate the number of days between today and the date it was reported.

In column N I have =IF(K4="Y",(L4-A4),(A2-A4)) As you can see it works if the job is completed, but if there is no "Y" in K, then I want it to calculate days to today since we logged it. As you can see in N5, it doesnt like it.

 

[awoohaw]

=IF(K5="Y",(L5-A5),(A3-A5))

here you go

you don't need the extraneous parens. But, what happened in cell N5 with that formula? and you're now looking at A3 not A2

 

[FormR]

=IF(K5="Y",(L5-A5),(A3-A5))

here you go

In that formula you are doing A3 - A5 and A3 contains text

 

[Paul long]

would you be kind enough to post your data in a table or use the xl2bb add in (preferable). I cannot read your image in post 1, to try to recreate your scenario.

Unfortunately, I'm on a work PC so cant do addins.

 

[awoohaw]

Highlight cells A1:N6. right click COPY.
Come to the thread click inside a post, CLICK PASTE.

 

[Paul long]

Ah, fixed it, thanks, I need to fix the cell with the date in:

=IF(K5="Y",(L5-A5),($A$2-A5))

Didnt understand Awoohaw's reply but it led me back to the date cell changin as i dragged it down.
Thanks guys.

 

[awoohaw]

Ah, fixed it, thanks, I need to fix the cell with the date in:

=IF(K5="Y",(L5-A5),($A$2-A5))

Didnt understand Awoohaw's reply but it led me back to the date cell changin as i dragged it down.
Thanks guys.

You're welcome, but that is exactly what I said to do in post #6.

 

[Paul long]

......