IF-HTML-Testing
=IF(Condition, if True,if False)<>-2
dd=IF(Condition, if True,if False)-3
ee=IF(Condition, if True,if False)<br-4< p=””></br-4<>
=IF(B2>70,"Pass","Fail")-5
=IF(B2>70,”Pass”,”Fail”)-6
=IF(B2>70,”Pass”,”Fail”)-7
—Start of IF function page—The above is testing and experimentation—- ——- In its basic usage, the IF function tests for a condition and returns a result depending on whether the condition is true or false.=IF (logical_test, [value_if_true], [value_if_false])
=IF (Condition, if True , [If_False] )
Example 1:
=IF (B2=>70, “Pass”, “Fail”)
=IF(B2=>70,"Pass","Fail")
The If True and If False argument are optional. For example:
=IF(B2=>70,"Pass")
If a Fail condition is experienced, Excel will enter its default FALSE
Example 2:
Another basic IF function, the same basic logic in Example 1. If the gain is greater than $5, enter the text “Sell”, if not, enter the text “Hold”:
=IF(D2>5,"Sell","Hold")

=IF(B2="Y",A2*0.08,0)

=IF(C6<=30,B6,0)

^^^1
1-TESTING FOR FULL WIDTH WITH HEIGHT AND TEXT WRAP. |
^^^2
2-TESTING FOR FULL WIDTH WITH HEIGHT AND TEXT WRAP. TESTING FOR FULL WIDTH WITH HEIGHT AND TEXT WRAP. TESTING FOR FULL WIDTH |
Need to kill the underline. I’m guessing it’s in the CSS
^^^3
3-TESTING FOR FULL WIDTH WITH HEIGHT AND TEXT WRAP. TESTING FOR FULL WIDTH WITH HEIGHT AND TEXT WRAP. TESTING FOR FULL WIDTH WITH HEIGHT AND TEXT WRAP. |
^^^4
4-TESTING FOR FULL WIDTH WITH HEIGHT AND TEXT WRAP. TESTING FOR FULL WIDTH WITH HEIGHT AND TEXT WRAP. TESTING FOR FULL WIDTH WITH HEIGHT AND TEXT WRAP. |
4a-TESTING FOR FULL WIDTH WITH HEIGHT AND TEXT WRAP. TESTING FOR FULL WIDTH WITH HEIGHT AND TEXT WRAP. TESTING FOR FULL WIDTH WITH HEIGHT AND TEXT WRAP. |
^^^6
=IF —experimenting–test page—
^^See also Online HTML Editor in Firefox Bookmarks^^
In its basic usage, the IF function test for a condition and returns a result depending on whether the condition is true or false.
1@@@ =IF(Condition, if True,if False)-full page width
This looks the same as #1 except it’s not a table. There’s no padding on the top and bottom
^^^7
2@@@=IF(Condition,)-full page width-doesn’t wrap with w & h codes
Same as 6? Except with top and bottom padding
=IF(Condition, if True,if False) – 1.1 does not wrap
What’s the diff in #8 and &7?^^^9
=IF(Condition, if True,if False) – 1.1 does not wrap
What’s the difference in 9 and 8
^^^10
3@@@=IF(AND(Condition, if True,if False), Condition, True,False) – 2 this one wraps
Look like there is a width limitation. Test this one. It looks like a winner
^^^11
4@@@=SUMIFS(F5:F11,C5:C11,”red”) // sum if red
=SUMIFS(F5:F11,C5:C11,”blue”,) // sum if blue – 1.2