Thread: If to determine lessor of three values
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jo-Anne[_2_] Jo-Anne[_2_] is offline
external usenet poster
  
Posts: 4
Default If to determine lessor of three values
I am trying to build an IF statement that will return the lessor of three
values and although I think this should be easy, it's not working.

So my values a
H42 = 500
G44 = 400
G45 = 425

Here's my statement that's not working...
=IF(AND(H42<G44,H42<G45),IF(G44<G45,G44),H42)

thanks in advance
Reply With QuoteReply With Quote