Need help with Formula

[carl]

I am trying to create a formula to create two possible outcomes.

in simplistic terms if a cell has a + number to show result as FOC if a
negative result to display it as a positive number *1.175.

So +£25 = FOC
or -£25 = +£25

Please Help!!!

 

[Dave Peterson]

=if(a1>0,"FOC",-a1*1.175)

But what happens at 0?

What happened with your *1.175 in your sample?

 

[Carl]

Many thanks dave forgot to add it in the sample!!!!!!

0 would be FOC

THANKS!!!!

 

[Dave Peterson]

=if(a1>=0,"FOC",-a1*1.175)

should do it.

Many thanks dave forgot to add it in the sample!!!!!!

0 would be FOC

THANKS!!!!