How can i use 3 if formulas in 1 cell?

[LauraDaly]

Excel.pdf - Google Drive

Here is my question:

The last column is my total column and I’d like to put 3 if statements. If the totals in the Over/Under column are as followed.

IF the number is a negative in Column R put N/A in column T

IF the number is a positive in Column R put in Bold and Red in column T

Here is the tricky one,
IF all the health in the columns (B-H), plus column (J-L) go over what the agency pays (P), I want to make the column T read "Limit Reimbursement"

 

[mikerickson]

Actually, the second one is the impossible one one. Forumulas cannot change the boldness or font color of the result.


What do you want in T if the Sum of B:H and J:L is greater than P AND the value in R is negative.

 

[Special-K99]

"IF the number is a positive in Column R put in Bold and Red in column T"

Put what bold and red in column T ?
T contains either N/A if R is negative or "Limit Reimbursement" if your other condition applies.
What should T contain if both those conditions are false?

 

[LauraDaly]

If the answer is positive i'd like to font to be Bold and Red in column T.

In T there would have to be a value.

Either a positive number, which would be a payroll deduction
If its a negative number and is only medical, which would be N/A
If its a positive number that includes a reimbursement, which would be Limit Reimbursement

 

[Special-K99]

Read this carefully.

A cell can contain a value or a formula, not both and a cell's contents cannot change between a value and a formula (unless you use VBA).
A cell cannot change the value of another cell.

Bearing that in mind
If R13 is negative you want "N/A" in column T13.
So T13 must contain a formula to determine if R13 is negative or not.
So what do you want in T13 (as the result of that formula) if R13 is positive? There cannot be an existing value in T13 since we've just said it must contain a formula.

 

[LauraDaly]

I was able to do the boldness and font with formatting. Thank you

 

[mikerickson]

I'm glad that the Conditional formatting worked for your color issue.

But, about "the tricky one"

IF all the health in the columns (B-H), plus column (J-L) go over what the agency pays (P), I want to make the column T read "Limit Reimbursement"

what does "all the health in columns B-H plus column J-L" mean. Does it mean that you want to compare column P against the sum of all of those columns and have "Limit Reimbursement" if that sum is greater than the column P entry? Or does it mean that you want each of those columns compared against P and if all of them are over, then "Limit Reimbursement"


Also, as was mentioned above, what if the "tricky" rule says that T should be "Limit Reimbursement", but the number in column R is negative. In that situation both the tricky condition and the negative R condition are met, do you want column T to be "Limit Reimbursement" or "N/A"?