|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
July 17th, 2008, 01:53 PM
|
||||
|
||||
|
Using IF statement in excel formula to copy cell value(s)
Is it possible to use an IF statement inside an excel formula to copy the contents of that cell to another cell or sheet? I have tried to find similar answers on Google about this, but its always about copying the formula to other cells, not contents of cells.
Any help is greatly appreciated.
__________________
Otaku no Kamisama – God of the Geeks
|
|
#2
July 31st, 2008, 10:16 AM
|
|||
|
|||
|
Yes, it is possible... for instance, take the following formula (let's say we place this formula in cell A1):
=IF(A2>B2,E1,D1) Break it down.... if the value of A2 is greater than the value of B2, take the contents of E1 and put it in A1 (since A1 is where the formula was placed). If B2 is greater than A2, take the contents of D1 and put it in A1. Is this what you're looking for?
|
|
| Viewing: Dev Shed Forums > Operating Systems > Windows Help > Using IF statement in excel formula to copy cell value(s) |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
