If formula Help

B

brozark77

New Member
Joined
Oct 25, 2011
Messages
1
Beginner here.

I am trying to input a formula which will show the percentage over budget in black and the correct formula as well as the percengage under in red with the correct corresponding formula.

mlyqh.jpg
[/IMG]
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
Sort by date Sort by votes
Hi brozark77 and welcome to the board
Your picture is missing.
Please use below methods to post your data:

You can download and install two of following programs:

HTLMaker

or
Excel Jeanie


or using when using Internet Explorer just put a borders around your data in Excel and copy those cells into your post .
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Question Question
XLookup and IF formula
Replies
2
Views
143
RoryA
RoryA
K
  • Solved
Formula cell reference
Replies
3
Views
58
Micron
M
L
  • Question Question
Conditional formatting using icon set to show trend AND colour coding of cell based on a %
Replies
1
Views
253
etaf
etaf
S
  • Solved
Converting some MySQL into formula
Replies
4
Views
232
etaf
etaf
M
  • Question Question
Formula for unpaid leave adjustment
Replies
2
Views
126
Joe4
Joe4

Forum statistics

Threads
1,225,064
Messages
6,182,645
Members
453,128
Latest member
mike4slund

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top