Quizzes & Puzzles1 min ago
excel saga continued
3 Answers
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
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
Answers
1 to 3 of 3
Best Answer
No best answer has yet been selected by evedawn. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.1 to 3 of 3
Latest Posts
One World Built On A Firm Foundation
Music2 mins ago
Starmer's Approval Rating Plummets,
News4 mins ago
ChatterBank6 mins ago
Related Questions
Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.