Expense claim form to bring error messages

**MushroomFace** · 07-26-2013, 07:29 AM

Please see attached spreadsheet

*Once complete the spreadsheet will be locked and data can only be inputted into coloured cells.*

I have started my formula in column N "Check", I am testing this for possible error messages.

My current arguments are
1. Error message if VAT is entered but no Total (as there should always be a total)
2. Error message if Expense type is not selected (this needs to be allocated via dropdown menu in column D

However in cell N9, it doesn't pick up that there is no expense type selected.

Please help!

**Fotis1991** · 07-26-2013, 07:42 AM

So give a try to this.

=IF(AND(E8="",F8=""),"",IF(AND(E8="",F8<>0),"Error No Total",IF(E8=SUM(F8:M8),"OK","Error check expense type")))

**MushroomFace** · 07-26-2013, 08:16 AM

Yes!

Thank you!

**Fotis1991** · 07-26-2013, 09:06 AM

How can you use Conditional Formating.

--In Excel 2007 and 2010, Conditional Formatting is in the Styles group on the Home tab. In Excel 2003, Conditional Formatting is on the Format menu. See here how you can work using CF.