Thread: "If "Formula
View Single Post
  #1   Report Post  
tojo107
 
Posts: n/a
Default "If "Formula

A
1 10
2 17
Want formula for cell b1 that will look at A1, if <= 14, then A1*.5 . If
A1 is =15, then it would multiply the first 14*.5, then from 15 on up
multiply by 1.


Thanks,
Tom