Nested If Or Statement within If Or Statement?

[MAKlos]

Hello! First timer to mr.excel.com. So please excuse the lack of clear information, but hoping I provided enough information to make sense of it all!

I am calculating the bonus $ amount for a project for 2 types of bonus categories with 2 different criteria for each category based on the cycle time target of 60 days and 15 days as shown below.

For projects that are called Building that produce a cycle time of 60 days or less then you get 0.50% of the total revenue of the project
For projects that are called Emergency that produce a cycle time of 15 days or less then you get 0.50% of the total revenue of the project

I would to like to generate the above in a nested If Or statement within an If Or statement with the data presented below


F13 = Building or Emergency
I13 = cycle time value of 60
C13 = Revenue amount of $5521.78
$J$4 = 0.50% for Building
$J$5 = 0.50% for Emergency

Here is the formula :

=IF(OR(F13="Building",F13="Emergency"),(IF(OR(I13<=60,I13<=15),(C13*$J$4,C13*$J$5),0)))

I am using Excel 2016 Version

The values that are being a returned are either:

#VALUE!

$0.00

<colgroup><col></colgroup><tbody>
</tbody>

Here's the image of the spreadsheet :

Looking forward to the feedback,
MAKlos

 

[eduzs]

tRY THIS:

=IF(F13="Bulding",IF(I13<=60,$J$4,0),IF(F13="Emergency",IF(I13<=60,$J$5,0),0)*C13)

 

[MAKlos]

THANK YOU Kindly! Reads like I was looking at this all backwards when if statements just did it!

 

[eduzs]

Just a small adjustment:

=IF(F13="Building",IF(I13<=60,$J$4,0),IF(F13="Emergency",IF(I13<=60,$J$5,0),0))*C13