excel

[vinicius770]

Hello,

I am having trouble making a spreadsheet!

In column C3 I insert a quantity that in C4 should calculate only when J7 turns negative (like in image -1). Could someone help, please?!

-----------------------------------------------------------------------------------------------------------------

Olá,

Eu estou com dificuldade para elaborar uma planilha!

Na coluna C3 eu insiro uma quantidade que na C4 deve calcular somente quando a J7 virasse negativo (igual tá na imagem -1). Alguém poderia ajudar, por favor?! 

[#2]

@vinicius770 

=IF(J7<0,C3*J16,"")

Maybe with this formula. 

[#3]

 

@OliverScheurich :\

[#4]

@vinicius770 

=SI(J7<0;C3*J16;"")

[#5]

 

@OliverScheurich 

[#6]

@vinicius770 

=SE(J7<0;C3*J16;"")

[#7]

@OliverScheurich 

It didn't work, the J7 column when it becomes negative and green, you must calculate the C4 column multiplied by the amount of C3 

[#8]

@vinicius770 

The formula works as expected in my sheet.

[#9]

@OliverScheurich 

The correct would be after 1000, start charging, in the case of the last column 0,-1,-2....