Question: In Microsoft Excel, I'd like to use the IF function to create the following logic:
======================================================
Question: In Microsoft Excel, I need to write a formula that works this way:
===============================================================
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:
Question: In Microsoft Excel, I want to write a formula for 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