Two formulas in one cell

**bjwade62** · 04-20-2009, 05:07 PM

I'm looking for a way to add an alert to the formula below if the resulting number is a negative number. Would that be two formulas in one cell? Is there anyway to do that?

Thanks

=IF('SD - Worksheet'!H26>1000,'SD - Worksheet'!O26,IF('SD - Worksheet'!O26>100,'SD - Worksheet'!O26,'SD - Worksheet'!K26))

**oldchippy** · 04-20-2009, 05:14 PM

Hi,

Welcome to the forum, try this

HTML Code:

**teylyn** · 04-20-2009, 05:15 PM

Hi,

you could use conditional formatting to make the cell change dramatically when it contains a negative value (e.g. red background), or you could have an alert display in a neighbouring cell with a formula like

=IF(A1<0,"Warning!","")

**JBeaucaire** · 04-20-2009, 05:15 PM

Try this:
=IF('SD - Worksheet'!H26>1000,IF('SD - Worksheet'!O26>100,'SD - Worksheet'!O26,'SD - Worksheet'!K26),"No Value")

**bjwade62** · 04-21-2009, 10:57 AM

Thanks for all the replies. I used a combination of all of them.

**oldchippy** · 04-21-2009, 10:58 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save