excel saga continued

[evedawn]

I STILL hate Excel! You'll never convince me otherwise!

Today Q is regarding an IF statement.

I know how to do an IF statement but this particular Q on the test paper is getting to me:

"if the BOOKED figure is greater than or equal to 12, then return the value YES in the TARGET ME column, otherwise show by how much the bookings are less than the target figure (A positive or negative value is acceptable)"

The FIRST PART is EASY it's where it asks to show by how much the bookings are less than the target figure that has me stumped:

The part of the IF statement to get a YEs answer is: =IF(C5>=12,"Yes","????????")
What do i put in the second " "'s (where the ????? are) to get to this? PLEASE>>>>>>>>



The part of the IF stat

[factor-fiction]

Don't you just need to put in the calculation for Targets subtract Bookings?

[rojash]

=IF(C5>=12,"Yes",12-C5)

[evedawn]

oh fipping heck.....how simple! THANK YOU. As mentioned I find excel hard. perhaps it's because it is logical ...and I am not :-(