# Combining Multiple IF Queries

#### apls2350

##### New Member
This three IF formulas in the below all work correctly when separated from the others but when combined Excel simply says the formula contains an error. I can't work out what's causing the issue?

=IF(\$CJ5=0,,IF(\$CJ5/30<1,((30-\$CJ5)*(\$CG5*'Revenue Forecast Weightings'!\$C\$4),IF(\$CJ5/30<2,\$H5*'Revenue Forecast Weightings'!\$C\$4+((60-\$CJ5)*\$CG5*'Revenue Forecast Weightings'!\$C\$5),IF(\$CJ5/30<3,\$H5*'Revenue Forecast Weightings'!\$C\$4+\$H5*'Revenue Forecast Weightings'!\$C\$5+((90-\$CJ5)*\$CG5*'Revenue Forecast Weightings'!\$C\$6,)))

### Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

#### apls2350

##### New Member
Fixed, please don't respond.

Replies
0
Views
40
Replies
1
Views
50
Replies
3
Views
21
Replies
0
Views
15
Replies
1
Views
212

1,109,367
Messages
5,528,271
Members
409,813
Latest member
robyrux

### This Week's Hot Topics

• Change military grades into rank
Afternoon all Need help with formula that will change military rank (i.e. 1, 2, 3 into Amn, A1C, SrA). Running IF formula that does not work...
• VBA COUNTIF SOLUTION
Hi The following are the errors spread across the several columns from E to Q ie. 13 columns across several sheets with more than 500 rows per...
• INSERT ROW WITH SPECIFIS TEXT IN A COLUMN
Hi All! How can identify that that the row to be inserted has to be inserted before 1st row with specific text in column F. If I record the...
• Auto-Create a monthly Sign in sheet for preschool students
The image below is what each page looks like. Above is space for the "Child Name" "Month" "Class" School days are obviously Monday-Friday but...
• VBA vlookup multiple results
Hi folks, Hopefully someone out there can help. I have a list to vlookup which works (ish). the lookup only picks up the first instance of the...
• Extract values for earliest/latest times
I am trying to put together a formula to get the earliest start time, the latest end time from column A for each person in Column B-F without the...