I needs formulas to solves these questions please,in I have the solutions too but I cant find the correct formulas of the logical function

prelab4 (Protected View) Word References Mailings Review View Tell me what you want to do Determine if a property is sold for no less than the asking price - In cell F2, write a formula which can be copied down the column to cells F3 F8, to determine if the property sold for no less than the asking price -try using the following method of reasoning Do you want a Boolean value or an arithmetic value? Here it appears that the value we want is are either True or False. To obtain a Boolean (True/False) value you will need to use a Relational Expression and/or Boolean operator . If it's a Boolean value you require, consider this: Are you comparing just two things (more jellybeans than candy corn), or are you comparing a group of things (do all the candy items cost more than $1 or does at least one candy item cost less than $1)? If you are comparing more than two things you will require a Boolean operator or a Boolean operator in combination with relational operators. You will have a chance to practice with these in subsequent questions. In the simplest case, such as this one, you are trying to compare just two things- the selling price and the asking price. So you would use a relational operator alone Pre-lab 4 CS&E 2111 Determine if the selling price was below 95% of the asking price. In cell G2 write a formula, which can be copied down, to determine if the selling price was below 95% of the asking price. Do we want a Boolean value or an arithmetic value? If it is Boolean, are we comparing iust hwn thinas or a lict of items