Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
formula up to a maximum of 100, no greater than
My spreadsheet uses formulae to work out value, but our fees, or A3, is
capped at 900. So, with a formula of A3=A1*A2 where the values are 10*100, I need A3 to be 900 but if the value is 8*100, I need A3 to be 800 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
formula up to a maximum of 100, no greater than
=IF(OR(A1="",A2=""),"",MIN(900,A1*A2))
-- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "John5646" wrote in message ... My spreadsheet uses formulae to work out value, but our fees, or A3, is capped at 900. So, with a formula of A3=A1*A2 where the values are 10*100, I need A3 to be 900 but if the value is 8*100, I need A3 to be 800 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Greater than but less than formula | Excel Worksheet Functions | |||
Greater than Less than formula | Excel Discussion (Misc queries) | |||
FORMULA FOR if(GREATER THAN, BUT LESS THAN,THIS,OR THAT | Excel Worksheet Functions | |||
Greater than formula! | Excel Worksheet Functions | |||
Less than, Greater than Formula | Excel Discussion (Misc queries) |