Conditional formatting on a calculation in excel

0 votes
I have a performance tracker with three rows, such E3 for the budget, E4 for the actuals, and E5 for the variation. I want the variance to be calculated automatically, but only after I enter the actual value. The budget amount is currently entered into the variance cell when I run the computation because the real cell is currently blank.

Applying the algorithm to the chart with the budgets in place is what I want to do, but I don't want to see a number in the variance field until I enter the actual.
Apr 1, 2023 in Others by Kithuzzz
• 38,000 points
875 views

1 answer to this question.

0 votes

In E5, you could use

=IF(COUNTBLANK(E3:E4)=0,E3-E4,"") 

which would provide a blank result if either of the two above values is missing. However, if E3 or E4 are formulas that may result in an empty value, then I'd evaluate the result of each cell to determine if either were blank: 

=IF(AND(E3<>"",E4<>""),E3-E4,"").
answered Apr 1, 2023 by narikkadan
• 63,600 points

Related Questions In Others

0 votes
1 answer

In a excel formula I need to create a list of names on one sheet based upon criteria/data of another sheet

The final formula is: =IF(ROWS($H$3:H3)<=$I$1,INDEX(Personnel! ...READ MORE

answered Nov 25, 2022 in Others by narikkadan
• 63,600 points
1,126 views
0 votes
1 answer

Select a range in Excel based on the value of a cell

Try this: Dim WorkRng As Range Set WorkRng = ...READ MORE

answered Jan 29, 2023 in Others by narikkadan
• 63,600 points
746 views
0 votes
1 answer

Looking to create a conditional statement in excel

Try using a rule based on a ...READ MORE

answered Feb 7, 2023 in Others by narikkadan
• 63,600 points
479 views
0 votes
1 answer
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,740 points
1,245 views
0 votes
1 answer

ImportError: openpyxl is required for loading excel format files

Forget the PsychoPy complications for the time ...READ MORE

answered Oct 3, 2018 in Python by Priyaj
• 58,020 points
1,108 views
0 votes
1 answer

In Blue Prism how to split excel column data into TWO columns

This is how I am doing it. Dim ...READ MORE

answered Oct 15, 2018 in RPA by Priyaj
• 58,020 points
4,389 views
0 votes
1 answer

Excel Power Query: Using List.MatchAny on a column value

try this. let TableA = ...READ MORE

answered Oct 22, 2018 in Power BI by Annie97
• 2,160 points
4,276 views
0 votes
1 answer

How to add Conditional Formatting in Excel for a Range of Values

Three distinct rules are required, one for ...READ MORE

answered Oct 24, 2022 in Others by narikkadan
• 63,600 points
1,153 views
0 votes
1 answer

Excel Conditional Formatting based on Adjacent Cell Value

The row number used in the formula ...READ MORE

answered Oct 10, 2022 in Others by narikkadan
• 63,600 points
1,877 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP