IF Formula

[Unique Landscaping]

I am trying to write a formula that will place a phrase on my invoice if the
statement is true. So far I have =IF(B28>=1,Planted and Guaranteed for 1
Year²). I need this formula to also look at B29 and follow the same logic
test, but not duplicate the phrase if both cells are equal to or greater
than 1. B28 is planting fee for a small tree, B29 is a planting fee for a
large fee. If someone buys one of each type, I only need the phrase once.

Thanks!

 

[CyberTaz]

IF FormulaTry this as one option if you want the phrase inserted if *either*
B28 or B29 are >=1:

=IF(OR(B28,B29>=1),"Planted and Guaranteed for 1 Year","")

If you want the phrase to be inserted only if *both* B28 & B29 are >=1
replace the OR with AND

--
HTH |:>)
Bob Jones
[MVP] Office:Mac

I am trying to write a formula that will place a phrase on my invoice if the
statement is true. So far I have =IF(B28>=1,Planted and Guaranteed for 1
Year"). I need this formula to also look at B29 and follow the same logic
test, but not duplicate the phrase if both cells are equal to or greater
than 1. B28 is planting fee for a small tree, B29 is a planting fee for a
large fee. If someone buys one of each type, I only need the phrase once.

Thanks!

 

[JE McGimpsey]

Minor correction:

=IF(OR(B28>=1,B29>=1),"Planted and Guaranateed for 1 Year","")

Bob's formula will likely work if B28 is a non-negative integer.

Technically, though, since XL interprets any non-zero number as TRUE,
the True branch will be erroneously executed if the value in B28 is
either negative, or a fractional positive value less than 1.

[-infinity <In article <#[email protected]>,

 

[CyberTaz]

By Golly you're right ... again;-) Thanks for the catch!
--
Regards |:>)
Bob Jones
[MVP] Office:Mac

Minor correction:

=IF(OR(B28>=1,B29>=1),"Planted and Guaranateed for 1 Year","")

Bob's formula will likely work if B28 is a non-negative integer.

Technically, though, since XL interprets any non-zero number as TRUE,
the True branch will be erroneously executed if the value in B28 is
either negative, or a fractional positive value less than 1.

[-infinity <In article <#[email protected]>,

IF FormulaTry this as one option if you want the phrase inserted if
*either*
B28 or B29 are >=1:

=IF(OR(B28,B29>=1),"Planted and Guaranteed for 1 Year","")

If you want the phrase to be inserted only if *both* B28 & B29 are >=1
replace the OR with AND