LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default I need help with 'value_if_true'

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
IF function with value_if_true and value_if_false as equations emrobertson Excel Worksheet Functions 4 November 29th 05 09:15 PM
Value_If_true - Question Hayley44 Excel Worksheet Functions 2 October 14th 05 02:08 AM
Using a range as value_if_true in IF function Dmitry Kopnichev Links and Linking in Excel 14 October 12th 05 02:55 PM
Using a range as value_if_true in IF function Dmitry Kopnichev Excel Worksheet Functions 14 October 12th 05 02:55 PM
Value_if_true Cheryl Excel Worksheet Functions 2 September 30th 05 09:09 PM


All times are GMT +1. The time now is 05:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"