IF formula

L

lt73

Is there any way to show the results of an IF formula in a seperate cell. So
the formula is in A1 but I want to show the results in D3?
 
A

AccessHelp

Change the format of Cell A1 to Text, and type in the formula. Now Cell A1
will show the formula.

For Cell D3, change the format to General, and type in the formula. Now
Cell D3 will show the result, instead of showing the formula.

I hope that's what you want.
 
Top