Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
=IF(((H190.75)*AND(H200.75)),(((B16/B17)+4.68*(B18/B19))/(33650/SQRT(B12))),"N/A")
This is my current equation for a cell. It says that if two specific cell exced .75, then calcualte (((B16/B17)+4.68*(B18/B19))/(33650/SQRT(B12))), but if false display N/A. What i need it do is if (((B16/B17)+4.68*(B18/B19))/(33650/SQRT(B12)))1, i need say "INVALID FOR LFD". So if both cells don't exceed .75 i need it to say "N/A". If the value is 1 or less i need it to give me value And if it exceed's 1 i need the cell to say "INVALID FOR LFD" |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I set up multiple logical conditions on one result cell | Excel Worksheet Functions | |||
Advanced unique cell count with multiple conditions ... help! | Excel Worksheet Functions | |||
Cell values based upon multiple conditions | New Users to Excel | |||
Multiple Conditions in a cell | Excel Worksheet Functions | |||
setting two conditions for countif | Excel Worksheet Functions |