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

How long do you think until flying cars or taxis are common?

Discuss in The Lounge

Poll History