samedi 27 juin 2020

Spreadsheets IF Greater than 0, make another cell equal this

I'm new to spreadsheets and I'm trying to do something like this:

If cell H86 > 0, then make cell J93 have the same value as H86. However, if H86 < 0, then make the cell H93 equal H96.

I tried doing it like this:

=IFS(H86 > 0, J93 = H86, H86 < 0, H93 = H86)

I keep getting the output "False" in the cell I'm trying to do this in, instead of it changing the values in the other cells. If what I'm doing isn't possible is there something I can do to achieve this?

Aucun commentaire:

Enregistrer un commentaire