| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Formula
Hi i need an IF formula which basically says 'If the contents in cell A1 are
less that 60 and the contents of cell A2 is 4 i want A3 to then show 10%' is it even possible to have multiple if's in one formula? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Formula
Something like this in A3: =IF(AND(A1<60,A2=4),10%,"")
with A3 formatted as percentage to taste -- Max Singapore http://savefile.com/projects/236895 Downloads:21,000 Files:365 Subscribers:65 xdemechanik --- "Jemma" wrote: Hi i need an IF formula which basically says 'If the contents in cell A1 are less that 60 and the contents of cell A2 is 4 i want A3 to then show 10%' is it even possible to have multiple if's in one formula? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Formula
excellent thank you
"Max" wrote: Something like this in A3: =IF(AND(A1<60,A2=4),10%,"") with A3 formatted as percentage to taste -- Max Singapore http://savefile.com/projects/236895 Downloads:21,000 Files:365 Subscribers:65 xdemechanik --- "Jemma" wrote: Hi i need an IF formula which basically says 'If the contents in cell A1 are less that 60 and the contents of cell A2 is 4 i want A3 to then show 10%' is it even possible to have multiple if's in one formula? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Formula
Welcome
-- Max Singapore http://savefile.com/projects/236895 Downloads:21,000 Files:365 Subscribers:65 xdemechanik --- "Jemma" wrote in message ... excellent thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
