LinkBack URL
About LinkBacks
Hi, i really would appreciate if anyone can help me. is it possible to compare two sets of data (can be numerica or alpha) and produce a different outcome comments.
Attached workbook might explain better.
Comparing two cells of data to produce a comment
Hi, i really would appreciate if anyone can help me. is it possible to compare two sets of data (can be numerica or alpha) and produce a different outcome comments.
Attached workbook might explain better.
Last edited by LEEP2008; 09-13-2009 at 11:59 AM.
Yep. Read the forum rules, change your thread title and upload a workbook with some sample data
Sorry i've made the adjustments as requested, can you help?
In D2 and copy down, =IF(C2 < B2, "Below", IF(C2 > B2, "Above", "On target") )
Entia non sunt multiplicanda sine necessitate
Re: Comparing two cells of data to produce a comment
Thanks that works a treat.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks