| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional functions
I want to print true if the number in cell g7 or the number in h7 or the number in I7 is equal to the number in g38 AND the number in h38 is greater than 10. There are 2 conditions to be fulfilled. -- pytelium ------------------------------------------------------------------------ pytelium's Profile: http://www.excelforum.com/member.php...o&userid=25521 View this thread: http://www.excelforum.com/showthread...hreadid=499062 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditional functions
Try this:
=IF(AND(OR(G7=G38,H7=G38,I7=G38),H3810),"TRUE","F ALSE") "pytelium" wrote in message ... I want to print true if the number in cell g7 or the number in h7 or the number in I7 is equal to the number in g38 AND the number in h38 is greater than 10. There are 2 conditions to be fulfilled. -- pytelium ------------------------------------------------------------------------ pytelium's Profile: http://www.excelforum.com/member.php...o&userid=25521 View this thread: http://www.excelforum.com/showthread...hreadid=499062 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditional functions
=IF(H3810,IF(OR(G7=G38,H7=G38,I7=G38),TRUE,FALSE) )
paul remove nospam for email addy! "pytelium" wrote: I want to print true if the number in cell g7 or the number in h7 or the number in I7 is equal to the number in g38 AND the number in h38 is greater than 10. There are 2 conditions to be fulfilled. -- pytelium ------------------------------------------------------------------------ pytelium's Profile: http://www.excelforum.com/member.php...o&userid=25521 View this thread: http://www.excelforum.com/showthread...hreadid=499062 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditional functions
Thanks Guys,both work! -- pytelium ------------------------------------------------------------------------ pytelium's Profile: http://www.excelforum.com/member.php...o&userid=25521 View this thread: http://www.excelforum.com/showthread...hreadid=499062 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cannot use ISEVEN or ISODD functions in Conditional Formatting | Excel Worksheet Functions | |||
| Conditional Functions | Excel Worksheet Functions | |||
| Conditional format combined with functions | Excel Worksheet Functions | |||
| Multiple FIND functions in Conditional Formatting | Excel Worksheet Functions | |||
| conditional functions | Excel Worksheet Functions | |||
Linear Mode
