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

Qty	Service	Expenses	Total
1	600	20	620

<tbody>
</tbody>

=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)