Is the IF the best formula to use in this situation and help needed with it.

**mr63249** · 10-27-2008, 12:55 AM

Hi im trying to make up a order form so it can generate the stock I need to order according to the day. I have highlighted the problem areas so far. I have higlighted the date just in case there is a way of having the date automatic.

**arthurbr** · 10-27-2008, 03:34 AM

Hi, there seems to have been a little mix-up with parnthesis try
=IF($J$3="SUNDAY";L9-K9;IF($J$3="TUESDAY";M9-K9;IF($J$3="SUNDAY";N9-K9)))
There are also 2 tests on SUNDAY in this formula. I suppose one of them should be thursday, but not knowing which I didn't adapt the formula

**mr63249** · 10-27-2008, 04:26 AM

Yeah it should of been THURSDAY, sorry.

=IF($J$3="SUNDAY";L9-K9;IF($J$3="TUESDAY";M9-K9;IF($J$3="THURSDAY";N9-K9)))

Nope still doesnt work says formula contains an error then higlights sunday?

Thanks