| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Formula
can anyone help I would like to return a result based on the following scenario If cell A1 <10% return "0" or if cell A1 10% sum would then = cell A3-A4 Hope this makes sense -- martins ------------------------------------------------------------------------ martins's Profile: http://www.excelforum.com/member.php...o&userid=31616 View this thread: http://www.excelforum.com/showthread...hreadid=562128 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with Formula
I assumed that it's less than or equal to 10% =IF(A1<=10%,"0",A3-A4) VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=562128 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with Formula
Thanks for the help but its not quite returning the result I was looking for - probably because I am not explaining very well - I will try again - The result is based on 2 scenarios - If cell A1 <10% return "0" if 10% the result would be cell A3-A4 sorry if this still confuses -- martins ------------------------------------------------------------------------ martins's Profile: http://www.excelforum.com/member.php...o&userid=31616 View this thread: http://www.excelforum.com/showthread...hreadid=562128 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with Formula
What happens if it equals 10% -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=562128 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with Formula
If your not worried about it matching 10% then =IF(A1<10%,"0",A3-A4) VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=562128 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Linear Mode
