Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I have a IF AND formula read 2 different cells to be true
I want to create a conditinal function that references 2 cells to be true -
this is what I have used for the formula but it is not referencing the C29 value to be true before doing the rest. for example: =IF(AND(C29="X",G29<L29),1,G29/L29) Thanks for your help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Again-revealing the contents of formula | Excel Worksheet Functions | |||
How would this formula read | Excel Discussion (Misc queries) | |||
Formula or not? | Excel Worksheet Functions | |||
Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |