Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am by no means skilled in Excel but I need help with a formula. I am using
the spreadsheet to calculate product prices based on my cost. My sister helped me originally with the first two formulas and they still work perfectly but I can't seem to make new formulas using the same concept. The variable that I don't understand is $AA$x (x being 1,3,6 or 8). Here are the two formulas that do work: =IF((F2/64)*16<5,$AA$1,(F2/64*16)) =IF((F2/16)*8<8,$AA$3,(F2/16*8)) Now here are the three formulas I want to make work: =IF(((F2/64)*16)*3<18,$AA$3,((F2/64)*16)*3) =IF((F2/2)*3<26,$AA$3,(F2/2)*3) =IF((F2*2.5)<38,$AA$3,(F2*2.5)) The 3 after $AA$ seems to be the key but I don't know what it means nor can I find $AA$ in Excel Help anywhere. Any help please? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF function with value_if_true and value_if_false as equations | Excel Worksheet Functions | |||
Value_If_true - Question | Excel Worksheet Functions | |||
Using a range as value_if_true in IF function | Links and Linking in Excel | |||
Using a range as value_if_true in IF function | Excel Worksheet Functions | |||
Value_if_true | Excel Worksheet Functions |