IF cell Blank return the value to on or another cell

can you give some examples
F8 or any value in that column

isblank(f8) will give a false and true

BUT what does
G8:H8
mean ???
its just a range

looking at this logically then

return to where ???

F8 has
H8+G8

and the value will depend on if those values in H8 and G8 are positive or negative

if there is NO value in F8 , thats because G8 and H8 are blank, more likely 0 zero
BUT
as G8 or H8 is a formula , then will it ever return a blank and not just return zero ???

Even if they are blank, then F8 will be zero

but i dont see how they would be blank - with the sumproduct()

as i say
please would you provide some real examples in the sample spreadsheet, where cells are blank and expected results

here is a real example avec real values

If there is a value in the column G I need to say excel to consider only this value every time when there is one, otherwise I want him to return to the J or K columns.

There are 3 examples in the attached file.

G9= - 43.4 so I want him to make appear only this value in D9

G11 and G12 are blanks, so it should be either a negative value

D11=-3.62 (cause J11=-3.62)

neither positive

D12=16.5 (cause K12=16.5)

Thanks for your time !

how about
=IF(OR(J8="",K8=""),MAX(J8:K8),j8+k8)

i have added to column C
so it can be compared with column D

But these are all different columns to your original question

yeah, sry about that. I was trying to make it more simple for you.

it seems to works but if I put any value in G15, for example 20 , It doesn't return 20 in C15 but still -1.72.
I see you make him calculate the value directly but if ever there is a value in G column It has to consider it and not to return to the J or K columns

it's the same actually, I'll just use less columns

I'll try and let you know !

ok,
so i'm really missing the details here

probably me

What 2 columns are we now looking at to see if blank ?

you mention J , K and G now

sorry , as i say probably me

G9= - 43.4 so I want him to make appear only this value in D9

WHY ???
Is that because F is blank

so are we testing columns F and G only

=IF(OR(F8="",G8=""),MAX(F8:F8),F8+G8)

G11 and G12 are blanks, so it should be either a negative value

thats 2 different rows - row11 and row12 now compared

and now

D11=-3.62 (cause J11=-3.62)

sorry , as i say maybe me - i'm just not following

I your example = i was just following the values you had in the cells and matched those

oh, OK
thats great

but if not, just come back

Hi Etaf,

I recently saw that there is an error in my formula.
If I remember well you helped me with the formula in D column and Glenn Kennedy for the one in G:L columns. I'm not sure what would be easier to correct to meet the result I need to have in my file.

I try to upload an example with an explanation of the expected result but there is an error
Is there another way to send it ?

I upload an example with an explanation of the expected result.

ok,
dont see the example

also often useful to post the text in the post itself, so the spreadsheet does not need to be opened to see what the problem statement is - as other members may help if they saw the problem in a post

I need to do the sumproduct of multiple cells and then the subtraction of two values which could be positive and/or negatives.

So I have

=SUMPRODUCT(--(1+MOD((COLUMN(U20:BCH20)-COLUMN(U20));9)=1)*(U20:BCH20>0)*N(+U20:BCH20))=0

for the positive and negative values and

IF(IF(OR(G20="";H20="");MAX(G20:H20);G20+H20)=0;"";IF(OR(G20="";H20="");MAX(G20:H20);G20+H20))

formula which is supposed to calculate the difference. But in the cells with the first formula there is an error in my result if ever I have positive and negative value at the same time.

I try to upload the file but there is an error. I have "Upload of file failed" every time when I try

Do I have to create a new post ?

you were right, was too big

I'm sorry about that. I didn't think to remove the if function and to left only the formula I'm interested in.

If you are still needing assistance, please explain what you still need assistance with.

Originally Posted by AliGW

If you are still needing assistance, please explain what you still need assistance with.

Yes, I still need help and I explained what I try to do and attached my file with an example of the result and the expected result. There is no confidential information, I left a few columns and rows cause was thinking it's an example of the real file and what kind of formula need to use.

Don't understand very well where is the problem.

It is far from clear (to me) what you still need help with.