Formula error

[Woofaloo]

Last year I created a spreadsheet with the following formula:

=IF(ISBLANK(B20),"",B20*$E$9) entered under the services

NOTE cell E9 = 600

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Qty[/TD]
[TD]Service[/TD]
[TD]Expenses[/TD]
[TD]Total[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]600[/TD]
[TD]20[/TD]
[TD]620[/TD]
[/TR]
</tbody>[/TABLE]

=IF(OR(ISBLANK(B20)),"",(D20+E20)) entered under Total

OK this has worked until I upgraded to Microsoft One Drive and downloaded Office 2016.

Can anyone tell me if I have a problem in the formula or if you have noticed a glitch in Excel 2016?

Thanks,
Phylis

 

[Joe4]

Are you getting an error or unexpected results?
What exactly is being returned?

[COLOR=#333333]=IF(OR(ISBLANK(B20)),"",(D20+E20))[/COLOR]

Why do you have an OR statement for only one condition?
That is unnecessary.

You can just use:

[COLOR=#333333]=IF(ISBLANK(B20),"",D20+E20)[/COLOR]

If you are getting some unexpected error, what does this return?

=ISBLANK(B20)

 

[Dave Patton]

Are your cell references correct? What columns are your numbers in?

or is your sheet like the following?

Excel 2010
	B	C	D	E
19	Qty	Service	Expenses	Total
20	1	600.00	20.00	620.00
21
22
1c

Cell Formulas
Range	Formula
C20	=IF(ISBLANK(B20),"",B20*$E$9)
E20	=IF(ISBLANK(B20),"",C20+D20)