need a formula to look up values in two columns

[veena]

Hi, I need a formula that will look at the value in the column D and bring in
column E but if the value is 0 in Column D than i want it to bring it from
column C. I hope someone can help me with this.

A B C D E
Str ITEM Current Special PRICE
1 170 1000074 399 249
2 199 4101471 399 199
3 199 1000065 449 249
4 199 1884733 249 0
5 231 1962422 199 0
6 231 1962516 349 0
7 231 10052 249 174.3
8 281 9879 499 399
9 282 6965 499 299

 

[Marcelo]

on e2 use

=if(d2<>0),d2,c2)

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"veena" escreveu:

 

[veena]

the bracket after the zero was giving me an error but after removing it this
works. thank you soo much.