Slightly confused with your example you state the K4 should equal 1 or 5, but
in your example the 1 and 5 appear in J4

Assuming the 1 and 5 are in J4 - Two ways to solve this
=(J4=5)*K4+(J4=1)*(1-k4/100) - you will have to use conditional formating to
change the "presentation" of the numbers

second way
=if(J4=5,K4,if(J4=1,1-k4/100,"not one or five")) - you will have to use
conditional formating to change the "presentation" of the numbers
--
Wag more, bark less


"Wanna Learn" wrote:

Hello
Excel 2002 - involves 2 columns Column K and column J
If the value in K4 = 5 then whatever is in cell J4 in dollars
But if the value in K4 =1 then J4 €“ 100 in %
Example
Column J Column K Results should be
5 1375 $1,375
1 22 78%
Thanks in advance
I've have tried .....