Just need a little xcel translation

I am pretty good with excel, but never read a text can someone translate this logical for me in layman's terms?


cell value =

IF(D98=" ",0,C98+E98)

My understanding of the logical operator IF in programming

If true, then =
If false, then =
Please translate....or link me to help

 

If D98 is blank, then cell value = 0
If D98 is not blank, then cell value = C98+E98

 

Thanks then just this little adjustment translates as?

IF(D95=" ","",D95+E98)



Thanks again....

 

Actually, I misread the first one.
" " translates as a space - hit spacebar once
"" is a blank cell - no value

So IF(D98=" ",0,C98+E98) would mean:
If D98 has a value of space, cell value would be 0;
If D98 has a value other than space (even 2 spaces), cell value = C98 + E98.

IF(D95=" ","",D95+E98) would mean:
If D95 has a value of space, cell value would be 0;
If D95 has a value other than space (even 2 spaces), cell value = D95 + E98.
This may look odd because in this case if D95 = 0, cell value = 1; but if D95 = space, then cell value = blank, which may look like zero, but is actually the lack of value.

 

Ok, let me see if I get this syntax correct.

IF(D95=" ", (If the value of D95 = "space bar" , (then) "" (Null value), else sum of D95+E98 is the cell value

Ok, lost you here....
If the value of D95=0 that would be other than " ", and the cell value would be D95+E98 or in this example 0+E98 or just E98.
Am I missing something?


Thanks

 

No, I missed it. You are correct. The cell value would be 0+E98 or E98. Whenever I evaluate Excel functions I put them into a spreadsheet and assign values to the cells. I had assigned the value '1' to E98. So, in my version of it, cell value was indeed 1.

Sorry for the confusion. :-o

 

If D98= " " if true= 0 if false= the value of c98 + e98