 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / October 2007IF Formula
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! 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  SignatureHTH |:>) 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! 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 <#RzH5B$FIHA.4684@TK2MSFTNGP06.phx.gbl>, > IF FormulaTry this as one option if you want the phrase inserted if *either* > B28 or B29 are >=1: [quoted text clipped - 3 lines] > If you want the phrase to be inserted only if *both* B28 & B29 are >=1 > replace the OR with AND By Golly you're right ... again;-) Thanks for the catch! SignatureRegards |:>) Bob Jones [MVP] Office:Mac > Minor correction: > [quoted text clipped - 16 lines] >> If you want the phrase to be inserted only if *both* B28 & B29 are >=1 >> replace the OR with AND |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.