| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
IF AND function
Hi,
I'm trying to do and if then formula, but I need two "if" conditions... something like =if(condition,and(additional condition), result if true, result if false). I can't get it to work. Any suggestions? |
|
#2
|
|||
|
|||
|
Try something along these lines ..:
In say, C1: =IF(AND(A110,B1<50),30,"") -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Joy" wrote in message ... Hi, I'm trying to do and if then formula, but I need two "if" conditions... something like =if(condition,and(additional condition), result if true, result if false). I can't get it to work. Any suggestions? |
|
#3
|
|||
|
|||
|
This didn't work - anymore suggestions?
"Max" wrote: Try something along these lines ..: In say, C1: =IF(AND(A110,B1<50),30,"") -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Joy" wrote in message ... Hi, I'm trying to do and if then formula, but I need two "if" conditions... something like =if(condition,and(additional condition), result if true, result if false). I can't get it to work. Any suggestions? |
|
#4
|
|||
|
|||
|
Hi
then you'll need to be more specific about what you want as Max's answer shows the correct syntax for testing of two conditions in an if statement. so -what are the actual conditions -what are the actual cell references -what are the actual true and false statements Cheers JulieD "Joy" wrote in message ... This didn't work - anymore suggestions? "Max" wrote: Try something along these lines ..: In say, C1: =IF(AND(A110,B1<50),30,"") -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Joy" wrote in message ... Hi, I'm trying to do and if then formula, but I need two "if" conditions... something like =if(condition,and(additional condition), result if true, result if false). I can't get it to work. Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function in XL or in VBA for XL that pulls numeric digits from a t | Excel Discussion (Misc queries) | |||
| #VALUE in cell but pop up function box show right number | Excel Discussion (Misc queries) | |||
| Excel function help facilities | Excel Discussion (Misc queries) | |||
| I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
| how can i get the slope function to ignore missing data? | Excel Discussion (Misc queries) | |||
Hybrid Mode
