W
Wanna Learn
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 .....
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 .....