help with formula

[SS]

In k24 I have =IF(DATE(K7,J7,I7)-DATE(G7,F7,E7)>=6,295,0)
In k25 I have =IF(DATE(K7,J7,I7)-DATE(G7,F7,E7)>=10,295,"")

in both cells this returns 295 They relate to dates and 295 return is £s
If I complete a date over 2 weeks (k24 +k25) it completes ok If I just enter
1 weeks dates (k24) I am getting a #value error on this formula, which is
giving a 10% discount. (I hope)

In cell k26 =K24+K25*90%

I did try and change some cells so maybe I have messed up.
Can anyone spot mistakes.
thanks

 

[Bernard Liengme]

Could you please rephrase, I am having trouble following this.
Please tell us what it is you wish to accomplish
best wishes

 

[Dave Peterson]

Could you return 0 for k25? Maybe you could hide the 0 with conditional
formatting or a custom number format if you don't want to see it.

Or you could use a formula like:
=k24+N(k25)*90%

 

[SS]

Sorry, I think I may have found the issue

In k25 I have =IF(DATE(K7,J7,I7)-DATE(G7,F7,E7)>=10,295,"")

I have changed to this

In k25 I have =IF(DATE(K7,J7,I7)-DATE(G7,F7,E7)>=10,295,"0") (zero
included at the end instead of "")

When it was totalling I was getting a #VALUE! but after including the zero
it appears to work ok now.

My apologies about being unclear as I never fully understand formulas so
kind of struggle through them.

 

[SS]

Yes I think that was the problem by not returning 0 so when it was
totalling I was getting #VALUE! It is working now and yes conditional
formatting should do it.

thanks