# Solved I have to Compare three values in Excel

May 22, 2011 at 21:54:16
Specs: Windows XP
 Ms Excele.g A B C D1 Deal Date Value Date Diff. Type2 01/05/11 03/05/11 B2-A1 (2) Ready/Spot/Forward3I want in Column D2, if C2=0,"Read", or C2>=1 and C2<=3,"Spot", or C2>=4, "Forward"What would be the Formual

See More: I have to Compare three values in Excel

#1
May 23, 2011 at 03:36:41
 Try this:if C2=0,"Read", or C2>=1 and C2<=3,"Spot", or C2>=4, "Forward"=IF(C2=0,"READ",IF(AND(C2>=1,C2<=3),"SPOT",IF(C2>=4,"FORWARD","")))See how that works.MIKEhttp://www.skeptic.com/

Report •

#2
May 23, 2011 at 04:09:50
 Thanks Mike, It worked perfectly, Thank you once again.Ahsan

Report •

#3
May 23, 2011 at 05:31:46
 I have one more complex problem to resolve. I have the following Data:e.g. C G I O P1 Date Deal Currency Amount Counter Cur. Amount 23 5/20/11 USD 100,000 GBP 61,350 4 21/5/11 JPY 100,000 USD 1,21556There are so many records like this, what I need Currency and Date wise Report.

Report •

Related Solutions

#4
May 23, 2011 at 05:58:41
 1 - Since this is a different issue, please post it in a new thread.2 - Before you post, please click on the last line of this post and review the instructions on posting data in this forum.3 - When you ask your question in a new thread, please include some more details."I need Currency and Date wise Report" is not enough for us to work with.DerbyDad03Office Forum ModeratorClick Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •