Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If... Then statements
How can I get my Excel 2002 spreadsheet to process proper 'if then' style commands? I've tried to work this out using =if() but to no avail. E.G. Cell A1 contains a total. If the results of calculation X in B1 meet a specific criteria, I want Cell A1 to equal A1+10 i.e. basically I want to write =If(B1=10,A1=A1+10,0) I don't want to put an =if() statement in A1, since there needs to be more than one of the above 'if then' style statements applied at various points. I'm aware that I can't set a cell to have its own value plus x, but I hope the logic of what I'd like to do is clear! Any thoughts? Cheers, Baldy -- BaldySlaphead ------------------------------------------------------------------------ BaldySlaphead's Profile: http://www.excelforum.com/member.php...fo&userid=1260 View this thread: http://www.excelforum.com/showthread...hreadid=524743 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If... Then statements
Hi Baldy If A1 is a total, e.g. =SUM(Z1:Z10) could you change that to =SUM(Z1:Z10)+IF(B1=10,10,0) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=524743 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating my own user defined function help statements | Excel Worksheet Functions | |||
UDFunctions and nested If-the-else statements | Excel Worksheet Functions | |||
"IF Statements in Microsoft Excel | Excel Discussion (Misc queries) | |||
Linking two IF statements together | Excel Discussion (Misc queries) | |||
Nested IF statements | Excel Worksheet Functions |