Formula Help

[levanoj]

I have a simple formula in Cell C1 that goes as follows:

=A1+B1

Where all cells in columns A & B contain numeric values.

What I need is to have the formula tweeked to prompt me with an error message of "Exceeded port availability" if the sum of A & B exceeds the value of 12.

Can anyone advise on how to do this?

 

[circledchicken]

Hi,

This should do it:

=IF(A1+B1>12,"Exceeded port availability",A1+B1)

 

[VoG]

Try

=IF(A1+B1>12,"Exceeded port availability",A1+B1)

 

[levanoj]

Thanks gents, formula worked. Would there be any way to further tweek and add a "conditional format" where the cell is highlighted in red if this formula is true?

I'm sort of a novice to using conditional formatiing but hoping someone can walk me through it.

 

[VoG]

Yes. Select C1, Format > Conditional Formatting, click the drop down to select Formula Is and enter the formula

=A1+B1>12

then click the Format button, select a format then OK your way out.

 

[levanoj]

Perfect, thanks again.