**Question: In Microsoft Excel, I'd like to use the IF function to create the following logic:**

`if C11>=620, and C10="F"or"S", and C4<=$1,000,000, and C4<=$500,000, and C7<=85%, `

`and C8<=90%, and C12<=50, and C14<=2, and C15="OO", and C16="N", and C19<=48, and C21="Y",`

` then reference cell A148 on Sheet2. Otherwise, return an empty string.`

` `

` ===========================================`

**Question: In Microsoft Excel, I'm trying **
to use the IF function to return 0 if cell A1 is either < 150,000 or
> 250,000. Otherwise, it should return A1.

```
```

`==========================================`

**Question: In Microsoft Excel,**I'm trying to use the IF function to return 25 if cell A1 > 100 and cell B1 < 200. Otherwise, it should return 0.

======================================================

**Question: In Microsoft Excel, I need to write a formula that works this way:**

- IF (cell A1) is less than 20, then times it by 1,
- IF it is greater than or equal to 20 but less than 50, then times it by 2
- IF its is greater than or equal to 50 and less than 100, then times it by 3/
- And if it is great or equal to than 100, then times it by 4

===============================================================

**Question: In Microsoft Excel, I need a formula in cell C5 that does the following:**

IF A1+B1 <= 4, return $20

IF A1+B1 > 4 but <= 9, return $35

IF A1+B1 > 9 but <= 14, return $50

IF A1+B1 > 15, return $75

================================================

**Question: In Microsoft Excel, I need a formula that does the following:**

- IF the value in cell A1 is BLANK, then return "BLANK"
- IF the value in cell A1 is TEXT, then return "TEXT"
- IF the value in cell A1 is NUMERIC, then return "NUM"

**Question: In Microsoft Excel, I want to write a formula for the following logic:**

- IF R1<0.3 AND R2<0.3 AND R3<0.42 THEN "OK" OTHERWISE "NOT OK"

## No comments:

## Post a Comment