Previous Topic Next Topic

Conditional formula

Closed
chinna - Jul 23, 2009 at 08:31 AM
 Trowa - Jul 27, 2009 at 07:10 AM
Hello,

i want a formula in MS Excel for the below example.

Cell D2 Cell D3 Cell D4
Amount in USD @ 13/- Dual signatories Result
20960 ac
5450 ba
687 cb

i want a formula where in Cell D4 that the Text contained in Cell D3 is correct or not which is based on information in Cell D2

2 responses

Answer 1 / 2
Trowa
Jul 24, 2009 at 06:44 AM
Hi Chinna,

What are the conditions for cell D3 to be correct or incorrect?

I don't see the connection between D3 and D2.

Best regards,
Trowa
0
chinna
Jul 24, 2009 at 08:45 AM
hi trowa,

the conection between cell D2 and d3 is that if the amount in cell d2 is more than 20000 than cell d3 should be show the text as " aa or bb or ac or bc but not cc. so if the text in cell d3 shows for example as cc then in cell d4 i want answer as wrong if it is other than text cc in cell d3 than it should show as correct.

i hope u got the point,

thanks
0
Answer 2 / 2
Trowa
Jul 27, 2009 at 07:10 AM
Hi Chinna,

What you need is an IF formula in D4:

=IF(D3="cc";"Wrong";"Correct")

You might have to change the ";" into a "," depending on your excel version.

Hope this helps you, let me know if it doesn't

Best regards,
Trowa
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response