# Formula to Return 3 Different Results

1. ## Formula to Return 3 Different Results

I'm trying to get a formula that returns a percent for the follow days and only the last day with data. All previous days of data should return blank.

For cell D8: (last day with data, data is entered into D2 and D4)

D8 should return value from D6
E8 and beyond should return E7/\$H\$7

Also, is there a way to make it when a value is returned as #N/A I can make it be very small text?
I tried using conditional formatting but could find what I was looking for.

Thanks.

2. ## Re: Formula to Return 3 Different Results

I think that this is what you want, in D8, then drag right.

=IFERROR(D6,D7/\$H\$7)

You can't change font size with conditional formatting, maybe use it to change from bold to regular, then adjust the colour 1 shade of green darker / lighter than the background so that it is less prominent?

Font size could be changed with vba, but you would need to define the size for error and no error.

3. ## Re: Formula to Return 3 Different Results

As stated, you can't change the font size, but you could change the font colour and/or the background colour. You could select all the cells from C3:G6 and use the CF formula:
Formula:
`Please Login or Register  to view this content.`

4. ## Re: Formula to Return 3 Different Results

That works in a static sheet, but when I enter data the next day in it doesn't work.

The perctage only need to be in the current day (D8) and equal the Cumulative Actual %
and in days going forwar (E8:G8) and have the formula of E8/\$H\$7

5. ## Re: Formula to Return 3 Different Results

C8 and drag right?

=IF(D7="","",IFERROR(C6,C7/\$H\$7))

Having a second sample with an additional days data and the expected results would eliminate guessing.

6. ## Re: Formula to Return 3 Different Results

Worked like a charm. Thanks very much for the help.

7. ## Re: Formula to Return 3 Different Results

New quick method:

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1