Converting numbers to negative...

Hello everyone!!
Can anyone help me here?? Am tryin to make column U convert its value to negative if column S states "S" or if its in red.

Ive tried to add at the end of exsisting formula =IF(S3:S10001="S",*-1 but it didnt seem to work.
4lvis_bondarenko_0-1614981488644.png

Which number are you trying to convert to negative when column S = "S"?

The picture you've attached is tiny so it's not easy to work out what you're trying to do.

A sample workbook, rather than a pic, would be much more helpful.

BSB

Any number in column U has to be converted to negative if colums S="S"

What is in Column U... formulas or numerical constants?

Did you want the negative values to appear in the same column (Column U) or in a different column (if so, which one)?

Its formulas in column U, and yes I want a negative values appear in column U if column S states "S".

Follow what Jeff said in post #3.

Add *IF(S3="S",-1,1) to the end of the formula you already have in U3 and copy it down to the other cells in that column.

BSB

Doesnt do anything Attachment 722153

To attach a file, you must follow the directions in the yellow banner at the top of this window.

Here is the sample.

Originally Posted by BadlySpelledBuoy

You cannot reference multi row ranges in formulas like you have. Well not in an IF and not like you have here anyway..

Try this in U3 and copy down.

Formula:

Please Login or Register  to view this content.

BSB

Thanks mate..working fine now. Only thing is the blank cells fills with "FALSE". Is there any way to keep them blank??

This in U3 will leave the cell blank if neither T1, T1&T2 nor S are selected in S3.

Formula:

Please Login or Register  to view this content.

Worth noting that you'll also need to tidy up some of your other formulas.
You need this in L3

Formula:

Please Login or Register  to view this content.

This in N3

Formula:

Please Login or Register  to view this content.

And this in P3

Formula:

Please Login or Register  to view this content.

Then all copied down as appropriate.

BSB

Thanks mate, really apricate your effort.

No problem at all mate. Happy to help

Could have had the solution this time yesterday had you posted a sample workbook in the first place

BSB