Function

How to get that working?

 

I need a function to apply values based on a character in a cell.

 

For example:

If there is a character P ( plus ) in cell B1 then function should use same value in cell C1 as in cell A1.

If there is a character M ( minus ) in cell B1 then function should change the sing of value in cell A1 and use it in cell C1

If cell B1 is empty then cell C1 should remain empty as well.

 

 

A

B

C

1

3

P

3

2

4

M

-4

3

4

 

 

 

Thanks for any help

By: Marcisz

Leave a Reply

Your email address will not be published. Required fields are marked *