Help with formula

[Richard]

Can't figure out how to format formula for all three conditions?
Thanks in advance!!
If(C3 is between 5.5 - 6.0 Then "OK"
If(C3 < 5.5 Then "Raise with Sodium Hydroxide"
If(C3 > 6.0 Then "Lower with Acedic Acid"

 

[Jim Cone]

Separate posts work best...
=IF(C3<5.5,"Raise with Sodium Hydroxide",IF(C3>6,"Lower with Acidic Acid","OK"))
--
Jim Cone
Portland, Oregon USA
http://www.contextures.com/excel-sort-addin.html
(Sorting add-in)

..
..
..

"Richard" <[email protected]>
wrote in message
Can't figure out how to format formula for all three conditions?
Thanks in advance!!
If(C3 is between 5.5 - 6.0 Then "OK"
If(C3 < 5.5 Then "Raise with Sodium Hydroxide"
If(C3 > 6.0 Then "Lower with Acedic Acid"