Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

If cell does not equal fixed amount-display error

0

I have a spreadsheet that our auditors use that is supposed to add up the number of rooms in our hotel that are inputed as dirty/clean/out of order/booked, etc. The total number of rooms should be 181. That never changes. Right now, we do the auto sum function for the column and the auditors haven't been double checking that it equals 181. I want to make the cell read Error or False if the numbers do not equal 181 so that the auditors are forced to check their numbers. So cells F3, F4, F5, F6 should equal 181 and if they input wrong numbers, I want F7 to read an error. How can I do that?

Answer
Discuss

Discussion

Please don't forget to select the answer that worked for you! Just click the Select Answer button at the bottom of it. If no answer worked, please clarify.
don (rep: 1989) Dec 5, '17 at 6:16 am
Add to Discussion

Answers

0
[F7] = IF(SUM($F$3:$F$6)<>181,"ERROR","")

This formula will leave F7 blank when all's well. If you prefer a confirmation, repalce the final "" with "Ok".

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login