Hi to all
Now in formula in H10
= IF(H10 = "", "", H9-H10)
is it possible to change like this:
if H10 < than H9 do H9-H10
IF H10 > than H9 do H10-H9
thanks you
xam
Hi to all
Now in formula in H10
= IF(H10 = "", "", H9-H10)
is it possible to change like this:
if H10 < than H9 do H9-H10
IF H10 > than H9 do H10-H9
thanks you
xam
= IF(H10 = "", "", IF( H10 < H9, H9-H10, IF(H10 > H9, H10-H9, " H10 is equal to H9")) )
I maybe mis-reading but you cant have a formula in H10 that refers to itself, circular reference
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
=if (H10 < than H9, H9-H10, H10-H9)
What if H9 = H10 ? 0
=if (H10 < =than H9, H9-H10, H10-H9)
or easier still
=ABS(H10-H9)
Last edited by mehmetcik; 11-12-2021 at 02:41 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
= if(h10 = "", "", abs(h9-h10))
Thank you
you can insert the sign
+ / -
to the left of the value colum G
IF H10 < than H9 do H9-H10 = sign - in value column G
IF H10 > than H9 do H10-H9 = sign + in value column G
I10
=IF(H10,IF(H10>H9,"+","-"),"")
or K10
=G10-G9
Custom format +;-
the result in column G must be as a column J
Last try G10
= IF(H10,H10-H9,"")
Custom format
[Blue] + 0.0000;[Red] - 0.0000
Thank you, bo_ry
A greeting
xam
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks