Question

IF function on EXCEL

Percentage of the year completed	% Probable Outlook	Budget >5%
16%	43%	X
16%	45%	X
16%	49%	X
16%
16%	34%	X
16%	42%	X
16%	49%	X
16%	0%	X
16%	48%	X
16%	100%	X
16%	46%	X
16%	45%	X
16%	49%	X
16%	97%	X
16%	44%	X
16%	90%	X
16%	45%	X
16%	47%	X

1. In column Budget >5%, create formulae using an appropriate function or functions on EXCEL to compare column % Probable Outlook with column Percentage of Year Completed and automatically display the words ‘Over budget’ whenever there is a greater than +5% difference. The cell should display a blank cell if the condition is not met. Insert a comment that explains how the formula works. Use the following items in the formulae: “Over budget” Percentage_of_the_year_completed

Answer 1

The Excel formula will be:

=IF(B1-A1>5%,"Over Budget","") this will compute the difference of values in column % Probable Outlook and column Percentage of Year Completed, and if the difference is greater than 5% then it will print over budget, else if the if condition comes out to be false then it will keep the cell blank.

if you like the answer please provide a thumbs up.