Solved I have to Compare three values in Excel

May 22, 2011 at 21:54:16
Specs: Windows XP
Ms Excel

e.g
A B C D
1 Deal Date Value Date Diff. Type
2 01/05/11 03/05/11 B2-A1 (2) Ready/Spot/Forward
3
I 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

Report •


#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.

MIKE

http://www.skeptic.com/


Report •

#2
May 23, 2011 at 04:09:50
✔ Best Answer
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 P
1 Date Deal Currency Amount Counter Cur. Amount
2
3 5/20/11 USD 100,000 GBP 61,350
4 21/5/11 JPY 100,000 USD 1,215
5
6
There 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.

DerbyDad03
Office Forum Moderator

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Ask Question