If statements

**B1G0** · 10-25-2014, 08:30 AM

Hi I was looking some help on if statements.
I would like a formula that would show as 0 if less than 481 but show the number that is in the cell if more than 481

**alansidman** · 10-25-2014, 08:39 AM

Assume data in A1, formula in B1 =if(A1<481, 0, A1)

**boopathiraja** · 10-25-2014, 08:40 AM

hI Try

Formula:

Please Login or Register  to view this content.

**B1G0** · 10-29-2014, 06:17 AM

Originally Posted by B1G0

Hi I was looking some help on if statements.
I would like a formula that would show as 0 if less than 481 but show the number that is in the cell if more than 481

Cheers alansidman

If statements

LinkBack

Thread Tools

Rate This Thread

Display

If statements

Re: If statements

Re: If statements

Re: If statements

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Nested if statements containing multiple and statements

Formula with multiple IF statements and IF AND statements

Reading If statements and formulating values from if statements

Nested IF statements or CHOOSE statements needed for multiple conditions formula

[SOLVED] operator statements, shorting when reusing one of the statements?

Bookmarks

Bookmarks

Posting Permissions