I am trying to say =if H3 is less than 0, find the amt of days( days360) between b3 and i3. but if there is a # in h3 I need to calculate the amt of days between(again I have to use the =days360 formula) b3 and L1.

I think I am close.. I am trying =if(h3<0=days360(b3,h3),=days360(b3,L1))

Drop the equal signs: =IF(H3<0, DAYS360(B3,H3), DAYS360(B3,L1))

P.S. There's nothing "advanced" about your statement. It's pretty much the standard use of IF.

Ask Your Question

Weekly Poll

Have you played Jackbox during the pandemic?

Discuss in The Lounge

Poll History